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

展开全部

灰常多，请耐心查看e68a84e8a2ad3231313335323631343130323136353331333262373963。

字符集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！

本回答由提问者推荐

已赞过

已踩过<

你对这个回答的评价是？

评论

收起