mysql 작업 시 한글 (UTF8)로 해도 물음표로 나오는 경우..



# mysql 또는 root 계정으로 작업을 권장합니다.
vi /etc/my.cnf


[client]
default-character-set = utf8


[mysqld]
init_connect = SET collation_connection = utf8_general_ci
init_connect = SET NAMES utf8
character-set-server = utf8
collation-server = utf8_general_ci


[mysqldump]
default-character-set = utf8


[mysql]
default-character-set = utf8



# service mysqld restart


# mysql -u root -p [엔터]


> use DB_NAME;
> show variables like 'c%';
+--------------------------+-----------------------------------------+
| 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/server/mysql/share/charsets/ |
| collation_connection     | utf8_general_ci                         |
| collation_database       | utf8_general_ci                         |
| collation_server         | utf8_general_ci                         |
| completion_type          | NO_CHAIN                                |
| concurrent_insert        | AUTO                                    |
| connect_timeout          | 10                                      |
+--------------------------+-----------------------------------------+


위와 같다면 드디어!! 한글이 출력!!! ㅠㅠ


TokenMarket ICO calendar