Show variables different results under phpMyAdmin and CLS?
Statement show variables like ' char% ';
Why are the results different under the phpMyAdmin and CLS
phpMyAdmin
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 latin1
Character_set_system UTF8
Character_sets_dir C:\Program files\mysql\mysql Server 5.1\share\char ...
Cls
Mysql> Show variables like ' char% ';
+--------------------------+---------------------+
| variable_name | Value |
+--------------------------+---------------------+
| character_set_client | Latin1 |
| character_set_connection | Latin1 |
| Character_set_database | UTF8 |
| Character_set_filesystem | binary |
| Character_set_results | Latin1 |
| Character_set_server | Latin1 |
| Character_set_system | UTF8 |
| Character_sets_dir | C:\Program Files\mysql\mysql Server 5.1\share\charsets\ |