什么是(默认的)字符集:
MySQL数据库 MySQL表 MySQL列
什么是(默认的)字符集:
MySQL数据库 MySQL表 MySQL列
当前回答
表:
SHOW TABLE STATUS将列出所有的表。
使用过滤:
SHOW TABLE STATUS where name like 'table_123';
其他回答
我是这么做的——
对于模式(或数据库-它们是同义词):
SELECT default_character_set_name FROM information_schema.SCHEMATA
WHERE schema_name = "schemaname";
表:
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 = "schemaname"
AND T.table_name = "tablename";
列:
SELECT character_set_name FROM information_schema.`COLUMNS`
WHERE table_schema = "schemaname"
AND table_name = "tablename"
AND column_name = "columnname";
表:
SHOW TABLE STATUS将列出所有的表。
使用过滤:
SHOW TABLE STATUS where name like 'table_123';
要查看数据库的默认排序规则:
USE db_name;
SELECT @@character_set_database, @@collation_database;
要查看表格的排序:
SHOW TABLE STATUS where name like 'table_name';
要查看列的排序规则:
SHOW FULL COLUMNS FROM table_name;
查看表的默认字符集
SHOW CREATE TABLE table_name;
数据库:
SELECT SCHEMA_NAME 'database', default_character_set_name 'charset', DEFAULT_COLLATION_NAME 'collation' FROM information_schema.SCHEMATA;
示例输出:
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 |
| drupal_demo1 | utf8 | utf8_general_ci |
| drupal_demo2 | utf8 | utf8_general_ci |
| drupal_demo3 | utf8 | utf8_general_ci |
| drupal_demo4 | utf8 | utf8_general_ci |
| drupal_demo5 | latin1 | latin1_swedish_ci |
...
+----------------------------+---------+--------------------+
55 rows in set (0.00 sec)
mysql>
数据库:
USE your_database_name;
show variables like "character_set_database";
-- or:
-- show variables like "collation_database";
参考本页。查阅MySQL手册