MySQL View all available character sets

MySQL View all available character sets

Enter Password:welcome to the MySQL Monitor. Commands End With; or \g.your MySQL connection ID is 6190Server version:5.6.24-log mysql Community Server (GPL) Copyright (c) #, Ora CLE and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.mysql> show character set;+----------+-----------------------------+-- -------------------+--------+| Charset | Description | Default Collation | MaxLen |+----------+-----------------------------+---------------------+--------+| Big5 | Big5 Traditional Chinese |      Big5_chinese_ci | 2 | | Dec8 | DEC West European |      Dec8_swedish_ci | 1 | | cp850 | DOS West European |      Cp850_general_ci | 1 | | HP8 | HP West European |      Hp8_english_ci | 1 | | koi8r |Koi8-r relcom Russian |      Koi8r_general_ci | 1 | | Latin1 | cp1252 West European |      Latin1_swedish_ci | 1 | | latin2 | ISO 8859-2 Central European |      Latin2_general_ci | 1 | | Swe7 | 7bit Swedish |      Swe7_swedish_ci | 1 | | ASCII | US ASCII |      Ascii_general_ci | 1 | | Ujis | EUC-JP Japanese |      Ujis_japanese_ci | 3 | | Sjis | Shift-jis Japanese |      Sjis_japanese_ci | 2 | | Hebrew | ISO 8859-8 Hebrew |      Hebrew_general_ci | 1 | | tis620 | TIS620 Thai |      Tis620_thai_ci | 1 | | Euckr | EUC-KR Korean |      Euckr_korean_ci | 2 | | koi8u | Koi8-u Ukrainian |      Koi8u_general_ci | 1 | | gb2312 | GB2312 Simplified Chinese |      Gb2312_chinese_ci | 2 | | Greek | ISO 8859-7 Greek |      Greek_general_ci | 1 | | cp1250 | Windows Central European | Cp1250_general_ci |      1 | | GBK | GBK Simplified Chinese |      Gbk_chinese_ci | 2 | | Latin5 | ISO 8859-9 Turkish |      Latin5_turkish_ci | 1 | | Armscii8 | ARMSCII-8 Armenian |      Armscii8_general_ci | 1 | | UTF8 | UTF-8 Unicode |      Utf8_general_ci | 3 | | UCS2 | UCS-2 Unicode |      Ucs2_general_ci | 2 | | cp866 | DOS Russian |      Cp866_general_ci | 1 | | KEYBCS2 | DOS Kamenicky Czech-slovak |      Keybcs2_general_ci | 1 | | Macce | Mac Central European |      Macce_general_ci | 1 | | Macroman | Mac West European |      Macroman_general_ci | 1 | | cp852 | DOS Central European |      Cp852_general_ci | 1 | | latin7 | ISO 8859-13 Baltic |      Latin7_general_ci | 1 | | UTF8MB4 | UTF-8 Unicode |      Utf8mb4_general_ci | 4 | | cp1251 | Windows Cyrillic |      Cp1251_general_ci | 1 | | UTF16 | UTF-16 Unicode | Utf16_general_ci | 4 | | Utf16le | Utf-16le Unicode |      Utf16le_general_ci | 4 | | cp1256 | Windows Arabic |      Cp1256_general_ci | 1 | | cp1257 | Windows Baltic |      Cp1257_general_ci | 1 | | Utf32 | UTF-32 Unicode |      Utf32_general_ci | 4 | | binary | Binary Pseudo CharSet |      binary | 1 | | Geostd8 | GEOSTD8 Georgian |      Geostd8_general_ci | 1 | | cp932 | SJIS for Windows Japanese |      Cp932_japanese_ci | 2 | | Eucjpms | Ujis for Windows Japanese |      Eucjpms_japanese_ci | 3 |+----------+-----------------------------+---------------------+--------+40 rows in Set (0.00 sec) mysql>

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

MySQL View all available character sets