MySQL character-set 확인 / MySQL 한글

MySQL character-set  을 확인하는 방법이다. 

한글이 잘 들어가기 위한 조건을 확인한다. 

 

1. 한글이 잘 안들어가는 경우의 캐릭터 셋

 

mysql> show variables like '%char%';
+--------------------------+----------------------------------------+
| Variable_name            | Value                                  |
+--------------------------+----------------------------------------+
| character_set_client     | euckr                                  |
| character_set_connection | euckr                                  |
| character_set_database   | latin1                                 |
| character_set_filesystem | binary                                 |
| character_set_results    | euckr                                  |
| character_set_server     | latin1                                 |
| character_set_system     | utf8                                   |
| character_sets_dir       | C:\mysql-5.7.28-winx64\share\charsets\ |
+--------------------------+----------------------------------------+
8 rows in set, 1 warning (0.05 sec)

 

 

2. 한글이 잘 들어가는 경우의 캐릭터 셋

 

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       | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.01 sec)

 

 

여기서 중요한 것은 

character_set_client     

character_set_database   

character_set_server     

이 3개 정도가 아닐까 한다. utf8 로 되어 있어야 한다.

 

 

그렇지 않은 경우 한글이 잘 들어가지 않고 오류가 발생할 수 있다.

 

https://webobj.tistory.com/55

Incorrect string value: '\xEC\xA0\x84\xEC\x9E\x90...' for column...

 

 

Done.