MySQL 8.0.25支持的字符集非常丰富,以下是详细的字符集列表:
Charset |Description |Default collation |Maxlen|
--------+-------------------------------+-------------------+------+
armscii8|ARMSCII-8 Armenian |armscii8_general_ci| 1|
ascii |US ASCII |ascii_general_ci | 1|
big5 |Big5 Traditional Chinese |big5_chinese_ci | 2|
binary |Binary pseudo charset |binary | 1|
cp1250 |Windows Central European |cp1250_general_ci | 1|
cp1251 |Windows Cyrillic |cp1251_general_ci | 1|
cp1256 |Windows Arabic |cp1256_general_ci | 1|
cp1257 |Windows Baltic |cp1257_general_ci | 1|
cp850 |DOS West European |cp850_general_ci | 1|
cp852 |DOS Central European |cp852_general_ci | 1|
cp866 |DOS Russian |cp866_general_ci | 1|
cp932 |SJIS for Windows Japanese |cp932_japanese_ci | 2|
dec8 |DEC West European |dec8_swedish_ci | 1|
eucjpms |UJIS for Windows Japanese |eucjpms_japanese_ci| 3|
euckr |EUC-KR Korean |euckr_korean_ci | 2|
gb18030 |China National Standard GB18030|gb18030_chinese_ci | 4|
gb2312 |GB2312 Simplified Chinese |gb2312_chinese_ci | 2|
gbk |GBK Simplified Chinese |gbk_chinese_ci | 2|
geostd8 |GEOSTD8 Georgian |geostd8_general_ci | 1|
greek |ISO 8859-7 Greek |greek_general_ci | 1|
hebrew |ISO 8859-8 Hebrew |hebrew_general_ci | 1|
hp8 |HP West European |hp8_english_ci | 1|
keybcs2 |DOS Kamenicky Czech-Slovak |keybcs2_general_ci | 1|
koi8r |KOI8-R Relcom Russian |koi8r_general_ci | 1|
koi8u |KOI8-U Ukrainian |koi8u_general_ci | 1|
latin1 |cp1252 West European |latin1_swedish_ci | 1|
latin2 |ISO 8859-2 Central European |latin2_general_ci | 1|
latin5 |ISO 8859-9 Turkish |latin5_turkish_ci | 1|
latin7 |ISO 8859-13 Baltic |latin7_general_ci | 1|
macce |Mac Central European |macce_general_ci | 1|
macroman|Mac West European |macroman_general_ci| 1|
sjis |Shift-JIS Japanese |sjis_japanese_ci | 2|
swe7 |7bit Swedish |swe7_swedish_ci | 1|
tis620 |TIS620 Thai |tis620_thai_ci | 1|
ucs2 |UCS-2 Unicode |ucs2_general_ci | 2|
ujis |EUC-JP Japanese |ujis_japanese_ci | 3|
utf16 |UTF-16 Unicode |utf16_general_ci | 4|
utf16le |UTF-16LE Unicode |utf16le_general_ci | 4|
utf32 |UTF-32 Unicode |utf32_general_ci | 4|
utf8 |UTF-8 Unicode |utf8_general_ci | 3|
utf8mb4 |UTF-8 Unicode |utf8mb4_general_ci | 4|
以上是MySQL 8.0.25所支持的详细字符集列表。你可以根据具体需求选择适合的字符集。
Tidb4.0.2支持的字符集非常丰富,以下是详细的字符集列表:
```sql
Charset|Description |Default collation|Maxlen|
-------+-------------+-----------------+------+
utf8 |UTF-8 Unicode|utf8_bin | 3|
utf8mb4|UTF-8 Unicode|utf8mb4_bin | 4|
ascii |US ASCII |ascii_bin | 1|
latin1 |Latin1 |latin1_bin | 1|
binary |binary |binary | 1|
下面是MySQL字符集和TiDB字符集的映射关系表格:
MySQL字符集|TiDB字符集
ascii|ascii
latin1|latin1
latin2|utf8
latin5|utf8mb4
latin7|binary
utf8|-
utf8mb4|utf8mb4
big5|-
gb2312|-
gbk|-
sjis|-
euckr|-
ucs2|-
utf16|-
utf16le|-
utf32|-
binary|binary
cp1250|-
cp1251|-
cp1256|-
cp1257|-
cp850|-
cp852|-
cp866|-
cp932|-
dec8|-
eucjpms|-
gb18030|-
geostd8|-
greek|-
hebrew|-
hp8|-
keybcs2|-
koi8r|-
koi8u|-
macce|-
macroman|-
swe7|-
tis620|-
ujis|-