mysql中charset和codepage的取值

Code Page    Character Set                                 语种  
708          ASMO-708                            阿拉伯字符   (ASMO 708) 
720          DOS-720                               阿拉伯字符 (DOS) 
28596        iso-8859-6                             阿拉伯字符   (ISO) 
1256         windows-1256                          阿拉伯字符 (Windows)  
1257         windows-1257                          波罗的海字符 (Windows)  
852          ibm852                                中欧字符 (DOS) 
28592        iso-8859-2                             中欧字符   (ISO) 
1250         windows-1250                          中欧字符 (Windows)  
936          gb2312                                 简体中文 (GB2312) 
52936        hz-gb-2312                             简体中文   (HZ) 
950          big5                                    繁体中文 (Big5) 
866          cp866                                   西里尔字符 (DOS) 
28595        iso-8859-5                              西里尔字符   (ISO) 
20866        koi8-r                                   西里尔字符 (KOI8-R) 
21866        koi8-ru                                  西里尔字符 (KOI8-U) 
1251         windows-1251                           西里尔字符   (Windows) 
28597        iso-8859-7                              希腊字符   (ISO) 
1253         windows-1253                           希腊字符   (Windows) 
862          DOS-862                                希伯来字符 (DOS) 
38598        iso-8859-8-i                             希伯来字符   (ISO-Logical) 
28598        iso-8859-8                                希伯来字符 (ISO-Visual) 
1255         windows-1255                           希伯来字符   (Windows) 
50932        _autodetect                              日语   (自动选择) 
51932        euc-jp                                   日语 (EUC) 
932          shift_jis                                  日语 (Shift-JIS) 
949          ks_c_5601-1987                           朝鲜语 
874          windows-874                               泰语 (Windows) 
1254         iso-8859-9                                 土耳其字符 (Windows) 
65001        utf-8                                   Unicode (UTF-8) 
1258         windows-1258                             越南字符   (Windows) 
1252         iso-8859-1                                 西欧字符

mysql> SHOW CHARACTER SET; 
+----------+-----------------------------+---------------------+ 
| 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    | ISO 8859-1 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     | 
| cp1251    | Windows Cyrillic             | cp1251_bulgarian_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    | 
| cp1256    | Windows Arabic               | cp1256_general_ci    | 
| cp1257    | Windows Baltic               | cp1257_general_ci    | 
| binary    | Binary pseudo charset        | binary               | 
| geostd8   | GEOSTD8 Georgian             | geostd8_general_ci   | 
+----------+-----------------------------+---------------------+
 

评论

发表新评论

此内容将保密,不会被其他人看见。
  • 允许HTML标签:<a> <img><em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd><p>
  • 自动断行和分段。

更多关於格式化选项的信息

Image CAPTCHA
验证码
|