현제 Database 서버 환경설정 값은
character set client utf8 utf8
character set connection utf8 utf8
character set database utf8 utf8
character set results utf8 utf8
character set server utf8 utf8
character set system utf8 utf8
character sets dir C:\PROGRA~1\EASYPH~1\mysql\share\charsets/ C:\PROGRA~1\EASYPH~1\mysql\share\charsets/
collation connection utf8_general_ci utf8_general_ci
collation database utf8_general_ci utf8_general_ci
collation server utf8_general_ci utf8_general_ci
그러나 dos prompt 에서는...
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\junho>cd C:\Program Files\EasyPHP1-8\mysql\bin
C:\Program Files\EasyPHP1-8\mysql\bin>mysql -uroot -p mysql
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 4.1.9-max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show variables like "%character%";show variables like "%collation%";
+--------------------------+--------------------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\PROGRA~1\EASYPH~1\mysql\share\charsets/ |
+--------------------------+--------------------------------------------+
7 rows in set (0.00 sec)
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)
현제 이렇게 설정 후에 localhost(웹)에서 query(한글)을 insert 하니 아예 값이 하나도 안들어가네요...
$charset = mysql_client_encoding($db);
printf("current character set is %s\n", $charset);
하니 값은 여전히.... latin1 이라고 나오네요...
이 문제때문에 하루를 낭비 했습니다.... 고수님들... 해결 부탁드려여 ..ㅜㅜ
|