mysql client에서는 한글이 전부 깨집니다.
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 | C:\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 | 5 |
+--------------------------+---------------------------------------------------------+
캐릭터셋 환경은 보이는대로 되어 있습니다.
왜 그런건지 궁금합니다.
my.ini는
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
character-set-client-handshake = FALSE
init_connect = "set names utf8"
#language=korean
이렇게 되있구요.
version은 5.0.51a-community-nt입니다.
그럼 이만.
|