Check the character set name and description : CHARSET « I18N « SQL / MySQL






  1. SQL / MySQL
  2. I18N
  3. CHARSET

Check the character set name and description

    
mysql>
mysql> SELECT   CHARACTER_SET_NAME, DESCRIPTION,
    ->          DEFAULT_COLLATE_NAME, MAXLEN
    -> FROM     INFORMATION_SCHEMA.CHARACTER_SETS;
+--------------------+-----------------------------+----------------------+--------+
| CHARACTER_SET_NAME | DESCRIPTION                 | DEFAULT_COLLATE_NAME | 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 |
| cp1251             | Windows Cyrillic            | cp1251_general_ci    |      1 |
| cp1256             | Windows Arabic              | cp1256_general_ci    |      1 |
| cp1257             | Windows Baltic              | cp1257_general_ci    |      1 |
| 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 |
+--------------------+-----------------------------+----------------------+--------+
36 rows in set (0.00 sec)

mysql>








Related examples in the same category

1.Set DEFAULT CHARSET=latin1
2.The CHARSET() function identifies the character set used for a specified string
3.Get CHARSET
4.Get the charset and collation information
5.Optionally, you can specify a default character set and sort order:
6.Change the Character Set of All Text Columns
7.MySQL Character Set Variables
8.Changing the Character Set
9.Specifying the Character Set of a Character String (Cast Operator)
10.CREATE DATABASE statement specifies the character set and collation:
11.To change the character set to latin1 for the BookSales database, use the following ALTER DATABASE statement
12.CONVERT( USING )
13.Check the character set
14.Character setting for char type column
15.CHARACTER SET utf8 for column definition
16.CHARACTER SET 'latin1', CHARACTER SET 'hp8'
17.Check the character set settings
18.Check the default character set name
19.Table with default chartset= latin1;
20.Set default character during table definition