MySQL 5.1 Reference Manual  /  ...  /  Character sets and collations

14.7.8 Character sets and collations

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 CollationSupported in IBM i 5.4Supported in IBM i 6.1
armscii8_general_ci
armscii8_bin
ascii_general_ci Yes
ascii_bin Yes
big5_chinese_ciYesYes
big5_binYesYes
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_ciYesYes
cp850_binYesYes
cp852_general_ci Yes
cp852_bin Yes
cp866_general_ci
cp866_bin
cp932_japanese_ciYesYes
cp932_binYesYes
dec8_swedish_ci
dec8_bin
eucjpms_japanese_ci
eucjpms_bin
euckr_korean_ciYesYes
euckr_binYesYes
gb2312_chinese_ciYesYes
gb2312_binYesYes
gbk_chinese_ciYesYes
gbk_binYesYes
geostd8_general_ci
geostd8_bin
greek_general_ciYesYes
greek_binYesYes
hebrew_general_ciYesYes
hebrew_binYesYes
hp8_english_ci
hp8_bin
keybcs2_general_ci
keybcs2_bin
koi8r_general_ci
koi8r_bin
koi8u_general_ci
koi8u_bin
latin1_danish_ciYesYes
latin1_general_ciYesYes
latin1_general_csYesYes
latin1_german1_ciYesYes
latin1_german2_ci
latin1_spanish_ciYesYes
latin1_swedish_ciYesYes
latin1_binYesYes
latin2_croatian_ciYesYes
latin2_czech_csYesYes
latin2_general_ciYesYes
latin2_hungarian_ciYesYes
latin2_binYesYes
latin5_turkish_ciYesYes
latin5_binYesYes
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_ciYesYes
sjis_binYesYes
swe7_swedish_ci
swe7_bin
tis620_thai_ciYesYes
tis620_binYesYes
ucs2_czech_ci Yes
ucs2_danish_ci Yes
ucs2_esperanto_ci Yes
ucs2_estonian_ci Yes
ucs2_general_ciYesYes
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_ciYesYes
ucs2_binYesYes
ujis_japanese_ciYesYes
ujis_binYesYes
utf8_czech_ci Yes
utf8_danish_ci Yes
utf8_esperanto_ci Yes
utf8_estonian_ci Yes
utf8_general_ciYesYes
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_binYesYes


User Comments
Sign Up Login You must be logged in to post a comment.