현재 설정된 문자셋 검사 방법

아래의 쿼리를 실행하면 현재 설정된 문자셋을 확인할 수 있다.

mysql> show variables like 'character_set_database';

+------------------------+-------+
| Variable_name              | Value  |
+------------------------+-------+
| character_set_database | euckr  |
+------------------------+-------+

1 row in set (0.00 sec)

 

mysql> show variables like 'character_set_%';
+--------------------------+----------------------------------------+
| Variable_name            | Value                                  |
+--------------------------+----------------------------------------+
| character_set_client     | latin1                                 |
| character_set_connection | latin1                                 |
| character_set_database   | euckr                                  |
| character_set_filesystem | binary                                 |
| character_set_results    | latin1                                 |
| character_set_server     | euckr                                  |
| character_set_system     | utf8                                   |
| character_sets_dir       | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)