mysql中数据库字符集是什么_如何查看MySQL数据库/表/列的字符集是什么？

For all the databases 您在服务器上：

mysql> SELECT SCHEMA_NAME 'database', default_character_set_name 'charset', DEFAULT_COLLATION_NAME 'collation' FROM information_schema.SCHEMATA;

输出：

+----------------------------+---------+--------------------+

| database | charset | collation |

+----------------------------+---------+--------------------+

| information_schema | utf8 | utf8_general_ci |

| my_database | latin1 | latin1_swedish_ci |

...

+----------------------------+---------+--------------------+

对于 single Database ：

mysql> USE my_database;

mysql> show variables like "character_set_database";

输出：

+----------------------------+---------+

| Variable_name | Value |

+----------------------------+---------+

| character_set_database | latin1 |

+----------------------------+---------+

获得整理 for Tables ：

mysql> USE my_database;

mysql> SHOW TABLE STATUS WHERE NAME LIKE 'my_tablename';

或 - 将输出create table的完整SQL：

mysql> show create table my_tablename

得到 columns 的整理：

mysql> SHOW FULL COLUMNS FROM my_tablename;

输出：

+---------+---------+--------------------+ ....

| field | type | collation |

+---------+---------+--------------------+ ....

| id | utf8 | (NULL) |

| key | utf8 | latin1_swedish_ci |

| value | utf8 | latin1_swedish_ci |

+---------+---------+--------------------+ ....