什么是(默认的)字符集:
MySQL数据库 MySQL表 MySQL列
什么是(默认的)字符集:
MySQL数据库 MySQL表 MySQL列
当前回答
要查看数据库的默认排序规则:
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;
其他回答
我总是看SHOW CREATE TABLE mydatabase。mytable。
对于数据库,似乎需要查看SELECT DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA。
我是这么做的——
对于模式(或数据库-它们是同义词):
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 CREATE DATABASE "DB_NAME_HERE";
在创建数据库(MySQL)时,默认字符集/排序规则总是LATIN,而不是在最初创建数据库时选择了不同的字符集/排序规则
正如前面所写的,SHOW FULL COLUMNS应该是获取列信息的首选方法。 缺少的是在不直接到达元数据表的情况下获取字符集的方法:
SHOW FULL COLUMNS FROM my_table WHERE Field = 'my_field'
SHOW COLLATION WHERE Collation = 'collation_you_got'
数据库:
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>