MySQL 文字コード確認

SHOW VARIABLES LIKE ‘char%’;

で確認できる

+————————–+—————————————————-
—–+
| Variable_name            | Value
     |
+————————–+—————————————————-
—–+
| character_set_client     | utf8
     |
| character_set_connection | utf8
     |
| character_set_database   | utf8
     |
| character_set_filesystem | binary
     |
| character_set_results    | utf8
     |
| character_set_server     | utf8
     |
| character_set_system     | utf8
     |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.0\share\chars
ets\ |
+————————–+—————————————————-