(기본값) 은 어떤 문자세트 대상:
MySQL 데이터베이스
MySQL 테이블
MySQL 열
스키마에는 위한 (또는 데이터베이스 - 그들은 동의어):
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";
USE your_database_name;
show variables like "character_set_database";
-- or:
-- show variables like "collation_database";
Cf. 이 페이지. 수동 및 체크아웃해야 mysql
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 |
...
+----------------------------+---------+--------------------+
mysql> USE my_database;
mysql> show variables like "character_set_database";
출력:
+----------------------------+---------+
| Variable_name | Value |
+----------------------------+---------+
| character_set_database | latin1 |
+----------------------------+---------+
mysql> USE my_database;
mysql> SHOW TABLE STATUS WHERE NAME LIKE 'my_tablename';
는 전체 또는 출력입니다 table: 만들기 위해 SQL
'mysql>. 쇼 my_tablename 테이블 만들기 '
mysql> SHOW FULL COLUMNS FROM my_tablename;
출력:
+---------+--------------+--------------------+ ....
| field | type | collation |
+---------+--------------+--------------------+ ....
| id | int(10) | (NULL) |
| key | varchar(255) | latin1_swedish_ci |
| value | varchar(255) | latin1_swedish_ci |
+---------+--------------+--------------------+ ....
< pre>; Table_schema 선택, TABLE_NAME, CCSA.CHARACTER_SET_NAME DEFAULT_CHAR_SET 있다, COLUMN_NAME, COLUMN_TYPE, C. CHARACTER_SET_NAME T 에서 information_schema.TABLES 있다 Bigadmin information_schema.COLUMNS 이용하여 C 로 (TABLE_SCHEMA, TABLE_NAME) Information_schema.collation_character_set_applicability 카사 참가하십시오 있다 ON (T. TABLE_COLLATION = CCSA.COLLATION_NAME) 여기서 TABLE_SCHEMA = 스키마 () 와 c 의 DATA_TYPE (& # 39, enum& # 39, & # 39, varchar& # 39, & # 39, char& # 39, & # 39, text& # 39, & # 39, & # 39 longtext& # 39 mediumtext& # 39;;;;) ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME . < /pre>;
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>