Mysql Char set 변경하기
* mysql server의 character set 변경하기
mysql이 설치된 경로에
path\my.ini
default-character-set=latin1 => default-character-set=utf8
등등 latin1이라고 되어 있는 부분을 utf8로 변경하시고 Reboot ^^
database
alter database [databasename] charset=utf8
table
alter table [tablename] charset=utf8
column
ALTER TABLE [tablename]
CHANGE [exists_columnname] [new_columnname] VARCHAR(10) CHARACTER SET utf8
대략 이런 형식이네..
설정확인
mysql> 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 | D:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 10 |
+--------------------------+---------------------------------------------------------+
14 rows in set (0.00 sec)