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 | G:\wamp\bin\mysql\mysql5.1.49\share\charsets\ | +--------------------------+-----------------------------------------------+ 8 rows in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'char%'; +--------------------------+-----------------------------------------------+ | Variable_name | Value | +--------------------------+-----------------------------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | G:\wamp\bin\mysql\mysql5.1.49\share\charsets\ | +--------------------------+-----------------------------------------------+ 8 rows in set (0.00 sec)Et, après un SET NAMES 'UTF8';
mysql> SET NAMES 'UTF8'; Query OK, 0 rows affected (0.00 sec) mysql> SHOW VARIABLES LIKE 'char%'; +--------------------------+-----------------------------------------------+ | Variable_name | Value | +--------------------------+-----------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | G:\wamp\bin\mysql\mysql5.1.49\share\charsets\ | +--------------------------+-----------------------------------------------+ 8 rows in set (0.00 sec)