MySQL 5.1 Reference Manual :: 14 Storage Engines :: 14.7 The IBMDB2I Storage Engine :: 14.7.8 Character sets and collations
Section Navigation [Toggle]
- 14.7 The IBMDB2I Storage Engine
- 14.7.1 Installation
- 14.7.2 Configuration Options
- 14.7.3 Creating schemas and tables
- 14.7.4 Database/metadata management
- 14.7.5 Transaction behavior
- 14.7.6 Principles and Terminology
- 14.7.7 Notes and Limitations
- 14.7.8 Character sets and collations
- 14.7.9 Error codes and trouble-shooting information
DB2 for i only supports a single collation per index or foreign key constraint. A foreign key constraint must have the same collation as a primary key constraint, if one exists..
Character sets and collations supported by
IBMDB2I are described in the list below. IBM i
6.1 is required for the most comprehensive collation support. Note
that Chinese, Japanese, and Korean character sets are converted to
UTF-16 for storage in DB2 for i;
utf8_general_ci is converted to
UCS2 for storage in DB2 for i.
Table 14.10. Collation Compatibility in IBMDB2I and MySQL
| MySQL Collation | Supported in IBM i 5.4 | Supported in IBM i 6.1 |
|---|---|---|
armscii8_general_ci | ||
armscii8_bin | ||
ascii_general_ci | Yes | |
ascii_bin | Yes | |
big5_chinese_ci | Yes | Yes |
big5_bin | Yes | Yes |
cp1250_croatian_ci | Yes | |
cp1250_czech_cs | Yes | |
cp1250_general_ci | Yes | |
cp1250_polish_ci | Yes | |
cp1250_bin | Yes | |
cp1251_bulgarian_ci | Yes | |
cp1251_general_ci | Yes | |
cp1251_general_cs | Yes | |
cp1251_ukrainian_ci | ||
cp1251_bin | Yes | |
cp1256_general_ci | Yes | |
cp1256_bin | Yes | |
cp1257_general_ci | ||
cp1257_lithuanian_ci | ||
cp1257_bin | ||
cp850_general_ci | Yes | Yes |
cp850_bin | Yes | Yes |
cp852_general_ci | Yes | |
cp852_bin | Yes | |
cp866_general_ci | ||
cp866_bin | ||
cp932_japanese_ci | Yes | Yes |
cp932_bin | Yes | Yes |
dec8_swedish_ci | ||
dec8_bin | ||
eucjpms_japanese_ci | ||
eucjpms_bin | ||
euckr_korean_ci | Yes | Yes |
euckr_bin | Yes | Yes |
gb2312_chinese_ci | Yes | Yes |
gb2312_bin | Yes | Yes |
gbk_chinese_ci | Yes | Yes |
gbk_bin | Yes | Yes |
geostd8_general_ci | ||
geostd8_bin | ||
greek_general_ci | Yes | Yes |
greek_bin | Yes | Yes |
hebrew_general_ci | Yes | Yes |
hebrew_bin | Yes | Yes |
hp8_english_ci | ||
hp8_bin | ||
keybcs2_general_ci | ||
keybcs2_bin | ||
koi8r_general_ci | ||
koi8r_bin | ||
koi8u_general_ci | ||
koi8u_bin | ||
latin1_danish_ci | Yes | Yes |
latin1_general_ci | Yes | Yes |
latin1_general_cs | Yes | Yes |
latin1_german1_ci | Yes | Yes |
latin1_german2_ci | ||
latin1_spanish_ci | Yes | Yes |
latin1_swedish_ci | Yes | Yes |
latin1_bin | Yes | Yes |
latin2_croatian_ci | Yes | Yes |
latin2_czech_cs | Yes | Yes |
latin2_general_ci | Yes | Yes |
latin2_hungarian_ci | Yes | Yes |
latin2_bin | Yes | Yes |
latin5_turkish_ci | Yes | Yes |
latin5_bin | Yes | Yes |
latin7_estonian_cs | ||
latin7_general_ci | ||
latin7_general_cs | ||
latin7_bin | ||
macce_general_ci | Yes | |
macce_bin | Yes | |
macroman_general_ci | ||
macroman_bin | ||
sjis_japanese_ci | Yes | Yes |
sjis_bin | Yes | Yes |
swe7_swedish_ci | ||
swe7_bin | ||
tis620_thai_ci | Yes | Yes |
tis620_bin | Yes | Yes |
ucs2_czech_ci | Yes | |
ucs2_danish_ci | Yes | |
ucs2_esperanto_ci | Yes | |
ucs2_estonian_ci | Yes | |
ucs2_general_ci | Yes | Yes |
ucs2_hungarian_ci | Yes | |
ucs2_icelandic_ci | Yes | |
ucs2_latvian_ci | Yes | |
ucs2_lithuanian_ci | Yes | |
ucs2_persian_ci | Yes | |
ucs2_polish_ci | Yes | |
ucs2_roman_ci | ||
ucs2_romanian_ci | Yes | |
ucs2_slovak_ci | Yes | |
ucs2_slovenian_ci | Yes | |
ucs2_spanish_ci | Yes | |
ucs2_spanish2_ci | Yes | |
ucs2_turkish_ci | Yes | |
ucs2_unicode_ci | Yes | Yes |
ucs2_bin | Yes | Yes |
ujis_japanese_ci | Yes | Yes |
ujis_bin | Yes | Yes |
utf8_czech_ci | Yes | |
utf8_danish_ci | Yes | |
utf8_esperanto_ci | Yes | |
utf8_estonian_ci | Yes | |
utf8_general_ci | Yes | Yes |
utf8_hungarian_ci | Yes | |
utf8_icelandic_ci | Yes | |
utf8_latvian_ci | Yes | |
utf8_lithuanian_ci | Yes | |
utf8_persian_ci | Yes | |
utf8_polish_ci | Yes | |
utf8_roman_ci | ||
utf8_romanian_ci | Yes | |
utf8_slovak_ci | Yes | |
utf8_slovenian_ci | Yes | |
utf8_spanish_ci | Yes | |
utf8_spanish2_ci | Yes | |
utf8_turkish_ci | Yes | |
utf8_unicode_ci | Yes | |
utf8_bin | Yes | Yes |
Copyright © 1997, 2013, Oracle and/or its affiliates. All
rights reserved.
Legal Notices
User Comments
Add your own comment.