Back

MYSQL 查看某个TABLE 的编码(check table encoding in mysql)

发布时间: 2013-08-17 01:33:00

mysql> SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, ->        information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
    -> WHERE CCSA.collation_name = T.table_collation
    ->   AND T.table_schema = "cms_development"
    ->   AND T.table_name = "cms_paid_videos";

+--------------------+
| character_set_name |
+--------------------+
| latin1             |
+--------------------+
1 row in set (0.03 sec)

mysql> SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,
    ->        information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
    -> WHERE CCSA.collation_name = T.table_collation
    ->   AND T.table_schema = "cms_development"
    ->   AND T.table_name = "cms_android_contents";
+--------------------+
| character_set_name |
+--------------------+
| utf8               |
+--------------------+
1 row in set (0.00 sec)

Back