| Oracle/MySQL 관련 게시판 |
|---|
| 2014/12/22(13:15) from 121.186.148.11 | |
| 작성자 : 주인장 | 조회수 : 2716 , 줄수 : 38 |
| [MySQL] UTF-8 한글 설정방법 |
|---|
|
1. my.cnf(linux) or my.ini(windows)를 편집한다. [client] default-character-set = utf8 [mysqld] default-character-set = utf8 character-set-server = utf8 collation-server = utf8_general_ci [mysqldump] default-character-set = utf8 [mysql] default-character-set = utf8 2. mysql restart 3. 확인 $ mysql -u root -p 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 | D:\APM_Setup\Server\MySQL5\share\charsets\ | +--------------------------+--------------------------------------------+ 8 rows in set (0.00 sec) |
|
|