ArtWorker's DataBase

MySQL UTF-8로 세팅하기


공부하자(smileemaker)  카페매니저   http://cafe.naver.com/painmaster/1158 


1. etc/my.cnf (또는 my.ini) 에서 캐릭터셋 수정
[client]
#password = your_password
default-character-set=utf8

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

[mysql]
default-character-set=utf8

2. 환경변수를 모두 수정후 mysql 서비스 재시작

3. mysql에서 캐릭터셋 확인
# mysql
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test
Database changed
mysql> show variables like 'c%';
+--------------------------+----------------------------+
| Variable_name                  | Value                                |
+--------------------------+----------------------------+
| character_set_client          | utf8                                    |
| character_set_connection  | utf8                                    |
| character_set_database     | utf8                                   |
| character_set_results        | utf8                                    |
| character_set_server         | utf8                                    |
| character_set_system        | utf8                                    |
| character_sets_dir            | /usr/share/mysql/charsets/ |
| collation_connection         | utf8_general_ci                    |
| collation_database           | utf8_general_ci                     |
| collation_server               | utf8_general_ci                     |
| concurrent_insert             | ON                                     |
| connect_timeout               | 5                                        |
+--------------------------+----------------------------+
12 rows in set (0.00 sec)

* MySql에서 데이터베이스 생성
mysql>CREATE DATABASE PAINBLOG DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;