10bet网址
MySQL内部手册


14.1.4字符集

MySQL有一个非常灵活的字符集支持字符集,排序规则,Unicode。字符集列表及其默认排序规则的名称和id可以如下查询:

mysql> SELECT CHARACTER_SET_NAME, COLLATION_NAME, ID FROM INFORMATION_SCHEMA。排序WHERE IS_DEFAULT = 'yes' ORDER BY ID;+--------------------+---------------------+-----+ | CHARACTER_SET_NAME | COLLATION_NAME | ID  | +--------------------+---------------------+-----+ | 繁体| big5_chinese_ci | 1 | | dec8 | dec8_swedish_ci | 3 | | cp850 | cp850_general_ci | 4 | | hp8 | hp8_english_ci | 6 | | koi8r | koi8r_general_ci 7 | | | latin1 |中的一个latin1_swedish_ci 8 | | | latin2 |9 latin2_general_ci | | | swe7 | swe7_swedish_ci 10 | | | ascii | ascii_general_ci 11 | | |里头| ujis_japanese_ci 12 | | | sjis | sjis_japanese_ci 13 | | |希伯来| hebrew_general_ci 16 | | | tis620 | tis620_thai_ci 18 | | | euckr | euckr_korean_ci 19 | | | koi8u | koi8u_general_ci 22 | | | gb2312 | gb2312_chinese_ci 24 | | | |greek_general_ci 25 | | | cp1250 | cp1250_general_ci 26 | | | gbk | gbk_chinese_ci 28 | | | latin5 | latin5_turkish_ci 30 | | | armscii8 | armscii8_general_ci 32 | | | utf8 | utf8_general_ci 33 | | | ucs2 | ucs2_general_ci 35 | | | cp866 | cp866_general_ci 36 | | | keybcs2 | keybcs2_general_ci 37 | | | macce | macce_general_ci 38 | | | macroman |macroman_general_ci 39 | | | cp852 | cp852_general_ci 40 | | | latin7 | latin7_general_ci 41 | | | cp1251 | cp1251_general_ci 51 | | | utf16 | utf16_general_ci 54 | | | utf16le | utf16le_general_ci | 56 | | cp1256 | cp1256_general_ci 57 | | | cp1257 | cp1257_general_ci 59 | | | utf32 | utf32_general_ci 60 | | |二进制二进制| | 63 | | geostd8 |geostd8_general_ci | 92 | | cp932 | cp932_japanese_ci | 95 | | eucjpms | eucjpms_japanese_ci | 97 | | gb18030 | gb18030_chinese_ci | 248 | | utf8mb4 | utf8mb4_0900_ai_ci | 255年  | +--------------------+---------------------+-----+

下表显示了一些常见的字符集。

数量

十六进制

字符集名称

8

(

latin1_swedish_ci

33

0 x21

utf8_general_ci

63

0 x3f

二进制

协议::CharacterSet

字符集在协议中定义为整数。

字段

  • charset_nr(2)——字符集和排序规则的编号

字符集ID实际上是排序规则ID。指定的排序规则意味着字符集和两者的名称都可以在INFORMATION_SCHEMA整理表格例如:

mysql> SELECT CHARACTER_SET_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA。排序表id = 255;+--------------------+--------------------+ | CHARACTER_SET_NAME | COLLATION_NAME  | +--------------------+--------------------+ | utf8mb4 | utf8mb4_0900_ai_ci  | +--------------------+--------------------+