HostMonster Web Hosting Help

MySQL Character sets supported

Problem:

What character sets are supported for MySQL?

Solution:

To see the options available for MySQL, Click Here

From this page, please click on the Demo Login... button. (This will work as it is a demo account, however if you have an account log in to your own cPanel instead.)

Once the CPanel is open, find the Databases section and click the phpMyAdmin icon. With this opened, you can see the character sets for MySQL.

MySQL supports 70+ collations for 30+ character sets. This section indicates which character sets MySQL supports. There is one subsection for each group of related character sets. For each character set, the allowable collations are listed.

You can always list the available character sets and their default collations with the SHOW CHARACTER SET statement:

This list is current as of September 2009.
Collation Description
armscii8 (ARMSCII-8 Armenian)
armscii8_bin Armenian, Binary
armscii8_general_ci Armenian, case-insensitive
ascii (US ASCII)
ascii_bin West European (multilingual), Binary
ascii_general_ci West European (multilingual), case-insensitive
big5 (Big5 Traditional Chinese)
big5_bin Traditional Chinese, Binary
big5_chinese_ci Traditional Chinese, case-insensitive
binary (Binary pseudo charset)
binary Binary
cp1250 (Windows Central European)
cp1250_bin Central European (multilingual), Binary
cp1250_croatian_ci Croatian, case-insensitive
cp1250_czech_cs Czech, case-sensitive
cp1250_general_ci Central European (multilingual), case-insensitive
cp1251 (Windows Cyrillic)
cp1251_bin Cyrillic (multilingual), Binary
cp1251_bulgarian_ci Bulgarian, case-insensitive
cp1251_general_ci Cyrillic (multilingual), case-insensitive
cp1251_general_cs Cyrillic (multilingual), case-sensitive
cp1251_ukrainian_ci Ukrainian, case-insensitive
cp1256 (Windows Arabic)
cp1256_bin Arabic, Binary
cp1256_general_ci Arabic, case-insensitive
cp1257 (Windows Baltic)
cp1257_bin Baltic (multilingual), Binary
cp1257_general_ci Baltic (multilingual), case-insensitive
cp1257_lithuanian_ci Lithuanian, case-insensitive
cp850 (DOS West European)
cp850_bin West European (multilingual), Binary
cp850_general_ci West European (multilingual), case-insensitive
cp852 (DOS Central European)
cp852_bin Central European (multilingual), Binary
cp852_general_ci Central European (multilingual), case-insensitive
cp866 (DOS Russian)
cp866_bin Russian, Binary
cp866_general_ci Russian, case-insensitive
cp932 (SJIS for Windows Japanese)
cp932_bin Japanese, Binary
cp932_japanese_ci Japanese, case-insensitive
dec8 (DEC West European)
dec8_bin West European (multilingual), Binary
dec8_swedish_ci Swedish, case-insensitive
eucjpms (UJIS for Windows Japanese)
eucjpms_bin Japanese, Binary
eucjpms_japanese_ci Japanese, case-insensitive
euckr (EUC-KR Korean)
euckr_bin Korean, Binary
euckr_korean_ci Korean, case-insensitive
gb2312 (GB2312 Simplified Chinese)
gb2312_bin Simplified Chinese, Binary
gb2312_chinese_ci Simplified Chinese, case-insensitive
gbk (GBK Simplified Chinese)
gbk_bin Simplified Chinese, Binary
gbk_chinese_ci Simplified Chinese, case-insensitive
geostd8 (GEOSTD8 Georgian)
geostd8_bin Georgian, Binary
geostd8_general_ci Georgian, case-insensitive
greek (ISO 8859-7 Greek)
greek_bin Greek, Binary
greek_general_ci Greek, case-insensitive
hebrew (ISO 8859-8 Hebrew)
hebrew_bin Hebrew, Binary
hebrew_general_ci Hebrew, case-insensitive
hp8 (HP West European)
hp8_bin West European (multilingual), Binary
hp8_english_ci English, case-insensitive
keybcs2 (DOS Kamenicky Czech-Slovak)
keybcs2_bin Czech-Slovak, Binary
keybcs2_general_ci Czech-Slovak, case-insensitive
koi8r (KOI8-R Relcom Russian)
koi8r_bin Russian, Binary
koi8r_general_ci Russian, case-insensitive
koi8u (KOI8-U Ukrainian)
koi8u_bin Ukrainian, Binary
koi8u_general_ci Ukrainian, case-insensitive
latin1 (cp1252 West European)
latin1_bin West European (multilingual), Binary
latin1_danish_ci Danish, case-insensitive
latin1_general_ci West European (multilingual), case-insensitive
latin1_general_cs West European (multilingual), case-sensitive
latin1_german1_ci German (dictionary), case-insensitive
latin1_german2_ci German (phone book), case-insensitive
latin1_spanish_ci Spanish, case-insensitive
latin1_swedish_ci Swedish, case-insensitive
Collation Description
latin2 (ISO 8859-2 Central European)
latin2_bin Central European (multilingual), Binary
latin2_croatian_ci Croatian, case-insensitive
latin2_czech_cs Czech, case-sensitive
latin2_general_ci Central European (multilingual), case-insensitive
latin2_hungarian_ci Hungarian, case-insensitive
latin5 (ISO 8859-9 Turkish)
latin5_bin Turkish, Binary
latin5_turkish_ci Turkish, case-insensitive
latin7 (ISO 8859-13 Baltic)
latin7_bin Baltic (multilingual), Binary
latin7_estonian_cs Estonian, case-sensitive
latin7_general_ci Baltic (multilingual), case-insensitive
latin7_general_cs Baltic (multilingual), case-sensitive
macce (Mac Central European)
macce_bin Central European (multilingual), Binary
macce_general_ci Central European (multilingual), case-insensitive
macroman (Mac West European)
macroman_bin West European (multilingual), Binary
macroman_general_ci West European (multilingual), case-insensitive
sjis (Shift-JIS Japanese)
sjis_bin Japanese, Binary
sjis_japanese_ci Japanese, case-insensitive
swe7 (7bit Swedish)
swe7_bin Swedish, Binary
swe7_swedish_ci Swedish, case-insensitive
tis620 (TIS620 Thai)
tis620_bin Thai, Binary
tis620_thai_ci Thai, case-insensitive
ucs2 (UCS-2 Unicode)
ucs2_bin Unicode (multilingual), Binary
ucs2_czech_ci Czech, case-insensitive
ucs2_danish_ci Danish, case-insensitive
ucs2_esperanto_ci Esperanto, case-insensitive
ucs2_estonian_ci Estonian, case-insensitive
ucs2_general_ci Unicode (multilingual), case-insensitive
ucs2_hungarian_ci Hungarian, case-insensitive
ucs2_icelandic_ci Icelandic, case-insensitive
ucs2_latvian_ci Latvian, case-insensitive
ucs2_lithuanian_ci Lithuanian, case-insensitive
ucs2_persian_ci Persian, case-insensitive
ucs2_polish_ci Polish, case-insensitive
ucs2_roman_ci West European, case-insensitive
ucs2_romanian_ci Romanian, case-insensitive
ucs2_slovak_ci Slovak, case-insensitive
ucs2_slovenian_ci Slovenian, case-insensitive
ucs2_spanish2_ci Traditional Spanish, case-insensitive
ucs2_spanish_ci Spanish, case-insensitive
ucs2_swedish_ci Swedish, case-insensitive
ucs2_turkish_ci Turkish, case-insensitive
ucs2_unicode_ci Unicode (multilingual), case-insensitive
ujis (EUC-JP Japanese)
ujis_bin Japanese, Binary
ujis_japanese_ci Japanese, case-insensitive
utf8 (UTF-8 Unicode)
utf8_bin Unicode (multilingual), Binary
utf8_czech_ci Czech, case-insensitive
utf8_danish_ci Danish, case-insensitive
utf8_esperanto_ci Esperanto, case-insensitive
utf8_estonian_ci Estonian, case-insensitive
utf8_general_ci Unicode (multilingual), case-insensitive
utf8_hungarian_ci Hungarian, case-insensitive
utf8_icelandic_ci Icelandic, case-insensitive
utf8_latvian_ci Latvian, case-insensitive
utf8_lithuanian_ci Lithuanian, case-insensitive
utf8_persian_ci Persian, case-insensitive
utf8_polish_ci Polish, case-insensitive
utf8_roman_ci West European, case-insensitive
utf8_romanian_ci Romanian, case-insensitive
utf8_slovak_ci Slovak, case-insensitive
utf8_slovenian_ci Slovenian, case-insensitive
utf8_spanish2_ci Traditional Spanish, case-insensitive
utf8_spanish_ci Spanish, case-insensitive
utf8_swedish_ci Swedish, case-insensitive
utf8_turkish_ci Turkish, case-insensitive
utf8_unicode_ci Unicode (multilingual), case-insensitive
Knowledgebase Article 69,571 views bookmark tags: character mysql set sets (updated 2132 days ago)


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

How to Set different character sets with PHP and HTML to display correctly. (updated 2115 days ago)
Knowledgebase Article 65,946 views tags: character language mysql php phpmyadmin sets

Instructions to set different character sets in HTML. Note: Not all character sets will be correctly rendered with this encoding format, but most will. You can find specific information about which ch (updated 1195 days ago)
Knowledgebase Article 73,697 views tags: arabic change character chinese html japanese language languages sets

Emails are not sending out in the correct character sets. Recipients are receiving odd characters instead of the specified set. (updated 1310 days ago)
Knowledgebase Article 54,765 views tags: character email mail php set

Related Help Content

This article will explain how to convert a MySQL database to UTF-8. (updated 49 days ago)
Knowledgebase Article 753 views tags: character database encoding mysql utf

I am prompted to set a new MySQL password. What does this mean and how do I change it? (updated 1092 days ago)
Knowledgebase Article 68,493 views tags: connect database mysql password phpmyadmin username

Do you allow the SUPER privilege on MySQL 5.x.x so I can use triggers ? (updated 1227 days ago)
Knowledgebase Article 52,328 views tags: mysql trigger

What is the character limit for the HostMonster.com form? (updated 2149 days ago)
Knowledgebase Article 100,800 views tags: cgi character form limit script

How can I connect to our MySQL database from Dreamweaver? (updated 1157 days ago)
Knowledgebase Article 101,168 views tags: connecting database dream mysql weaver

This article will explain how to change or reset the password for a MySQL user. (updated 65 days ago)
Knowledgebase Article 1,192 views tags: change mysql password reset user

Users having problems connecting to mysql database using SSH and/or putty/other client. (updated 1847 days ago)
Knowledgebase Article 62,747 views tags: connection ip mysql putty ssh whitelist

How do I make my MySQL database compatible with the version you provide? (updated 2148 days ago)
Knowledgebase Article 84,559 views tags: database mysql