MySQL中数据库的默认字符集和校对规则有哪些？

答案：灰常多，请耐心查看。

字符集Start-----------------------
Charset Description Default collation
big5 Big5 Traditional Chinese big5_chinese_ci
dec8 DEC West European dec8_swedish_ci
cp850 DOS West European cp850_general_ci
hp8 HP West European hp8_english_ci
koi8r KOI8-R Relcom Russian koi8r_general_ci
latin1 cp1252 West European latin1_swedish_ci
latin2 ISO 8859-2 Central European latin2_general_ci
swe7 7bit Swedish swe7_swedish_ci
ascii US ASCII ascii_general_ci
ujis EUC-JP Japanese ujis_japanese_ci
sjis Shift-JIS Japanese sjis_japanese_ci
hebrew ISO 8859-8 Hebrew hebrew_general_ci
tis620 TIS620 Thai tis620_thai_ci
euckr EUC-KR Korean euckr_korean_ci
koi8u KOI8-U Ukrainian koi8u_general_ci
gb2312 GB2312 Simplified Chinese gb2312_chinese_ci
greek ISO 8859-7 Greek greek_general_ci
cp1250 Windows Central European cp1250_general_ci
gbk GBK Simplified Chinese gbk_chinese_ci
latin5 ISO 8859-9 Turkish latin5_turkish_ci
armscii8 ARMSCII-8 Armenian armscii8_general_ci
utf8 UTF-8 Unicode utf8_general_ci
ucs2 UCS-2 Unicode ucs2_general_ci
cp866 DOS Russian cp866_general_ci
keybcs2 DOS Kamenicky Czech-Slovak keybcs2_general_ci
macce Mac Central European macce_general_ci
macroman Mac West European macroman_general_ci
cp852 DOS Central European cp852_general_ci
latin7 ISO 8859-13 Baltic latin7_general_ci
cp1251 Windows Cyrillic cp1251_general_ci
cp1256 Windows Arabic cp1256_general_ci
cp1257 Windows Baltic cp1257_general_ci
binary Binary pseudo charset binary
geostd8 GEOSTD8 Georgian geostd8_general_ci
cp932 SJIS for Windows Japanese cp932_japanese_ci
eucjpms UJIS for Windows Japanese eucjpms_japanese_ci
字符集End-----------------------
字符集--校验 关系Start------------------
Collation Charset Default
big5_chinese_ci big5 Yes
big5_bin big5 
dec8_swedish_ci dec8 Yes
dec8_bin dec8 
cp850_general_ci cp850 Yes
cp850_bin cp850 
hp8_english_ci hp8 Yes
hp8_bin hp8 
koi8r_general_ci koi8r Yes
koi8r_bin koi8r 
latin1_german1_ci latin1 
latin1_swedish_ci latin1 Yes
latin1_danish_ci latin1 
latin1_german2_ci latin1 
latin1_bin latin1 
latin1_general_ci latin1 
latin1_general_cs latin1 
latin1_spanish_ci latin1 
latin2_czech_cs latin2 
latin2_general_ci latin2 Yes
latin2_hungarian_ci latin2 
latin2_croatian_ci latin2 
latin2_bin latin2 
swe7_swedish_ci swe7 Yes
swe7_bin swe7 
ascii_general_ci ascii Yes
ascii_bin ascii 
ujis_japanese_ci ujis Yes
ujis_bin ujis 
sjis_japanese_ci sjis Yes
sjis_bin sjis 
hebrew_general_ci hebrew Yes
hebrew_bin hebrew 
tis620_thai_ci tis620 Yes
tis620_bin tis620 
euckr_korean_ci euckr Yes
euckr_bin euckr 
koi8u_general_ci koi8u Yes
koi8u_bin koi8u 
gb2312_chinese_ci gb2312 Yes
gb2312_bin gb2312 
greek_general_ci greek Yes
greek_bin greek 
cp1250_general_ci cp1250 Yes
cp1250_czech_cs cp1250 
cp1250_croatian_ci cp1250 
cp1250_bin cp1250 
cp1250_polish_ci cp1250 
gbk_chinese_ci gbk Yes
gbk_bin gbk 
latin5_turkish_ci latin5 Yes
latin5_bin latin5 
armscii8_general_ci armscii8 Yes
armscii8_bin armscii8 
utf8_general_ci utf8 Yes
utf8_bin utf8 
utf8_unicode_ci utf8 
utf8_icelandic_ci utf8 
utf8_latvian_ci utf8 
utf8_romanian_ci utf8 
utf8_slovenian_ci utf8 
utf8_polish_ci utf8 
utf8_estonian_ci utf8 
utf8_spanish_ci utf8 
utf8_swedish_ci utf8 
utf8_turkish_ci utf8 
utf8_czech_ci utf8 
utf8_danish_ci utf8 
utf8_lithuanian_ci utf8 
utf8_slovak_ci utf8 
utf8_spanish2_ci utf8 
utf8_roman_ci utf8 
utf8_persian_ci utf8 
utf8_esperanto_ci utf8 
utf8_hungarian_ci utf8 
ucs2_general_ci ucs2 Yes
ucs2_bin ucs2 
ucs2_unicode_ci ucs2 
ucs2_icelandic_ci ucs2 
ucs2_latvian_ci ucs2 
ucs2_romanian_ci ucs2 
ucs2_slovenian_ci ucs2 
ucs2_polish_ci ucs2 
ucs2_estonian_ci ucs2 
ucs2_spanish_ci ucs2 
ucs2_swedish_ci ucs2 
ucs2_turkish_ci ucs2 
ucs2_czech_ci ucs2 
ucs2_danish_ci ucs2 
ucs2_lithuanian_ci ucs2 
ucs2_slovak_ci ucs2 
ucs2_spanish2_ci ucs2 
ucs2_roman_ci ucs2 
ucs2_persian_ci ucs2 
ucs2_esperanto_ci ucs2 
ucs2_hungarian_ci ucs2 
cp866_general_ci cp866 Yes
cp866_bin cp866 
keybcs2_general_ci keybcs2 Yes
keybcs2_bin keybcs2 
macce_general_ci macce Yes
macce_bin macce 
macroman_general_ci macroman Yes
macroman_bin macroman 
cp852_general_ci cp852 Yes
cp852_bin cp852 
latin7_estonian_cs latin7 
latin7_general_ci latin7 Yes
latin7_general_cs latin7 
latin7_bin latin7 
cp1251_bulgarian_ci cp1251 
cp1251_ukrainian_ci cp1251 
cp1251_bin cp1251 
cp1251_general_ci cp1251 Yes
cp1251_general_cs cp1251 
cp1256_general_ci cp1256 Yes
cp1256_bin cp1256 
cp1257_lithuanian_ci cp1257 
cp1257_bin cp1257 
cp1257_general_ci cp1257 Yes
binary binary Yes
geostd8_general_ci geostd8 Yes
geostd8_bin geostd8 
cp932_japanese_ci cp932 Yes
cp932_bin cp932 
eucjpms_japanese_ci eucjpms Yes
eucjpms_bin eucjpms 
字符集--校验 关系END------------------
========================
如果你可以访问MYSQL的话。教你两个语句。直接查出来看。格式比这个好看。
SHOW CHARACTER SET 
SHOW COLLATION

如果需要。我有电子表格。
给我发邮件索要。liuhuanaiaiai@163.com。
Over！

上一个：链接mysql数据库时出现fatal error encountered during command execution
下一个：如何用mysql设计一个论坛数据库？