Mega Code Archive

 

Categories / MySQL / Internationalization

 

Check the default character set name

mysql> mysql> SELECT   SCHEMA_NAME, DEFAULT_CHARACTER_SET_NAME,     ->          DEFAULT_COLLATION_NAME     -> FROM     INFORMATION_SCHEMA.SCHEMATA; +--------------------+----------------------------+------------------------+ | SCHEMA_NAME        | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | +--------------------+----------------------------+------------------------+ | information_schema | utf8                       | utf8_general_ci        | | mysql              | latin1                     | latin1_swedish_ci      | | test               | latin1                     | latin1_swedish_ci      | +--------------------+----------------------------+------------------------+ 3 rows in set (0.00 sec) mysql>