Re: why client characterset and sever characterset are set to Latin when character set client and server are set to different character set

[Sam Ohn]

Ok, thank you for your suggestion. I tried these commands and got the same result from executing show global .... and show session ... And, executing STATUS shows Client and Server characterset variables are set to Latin1.
What should I do for next?

mysql> show global variables like 'chara%';
+--------------------------+--------------------------------+
| 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:\xampp\mysql\share\charsets\ |
+--------------------------+--------------------------------+
8 rows in set (0.00 sec)

mysql> show session variables like 'chara%';
+--------------------------+--------------------------------+
| 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:\xampp\mysql\share\charsets\ |
+--------------------------+--------------------------------+
8 rows in set (0.00 sec)

mysql> status
--------------
mysql  Ver 14.14 Distrib 5.1.41, for Win32 (ia32)

Connection id:          32
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.1.41 Source distribution
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 1 day 19 hours 2 min 41 sec

Threads: 1  Questions: 272  Slow queries: 0  Opens: 33  Flush tables: 1  Open ta
bles: 0  Queries per second avg: 0.1
--------------

Rick James Wrote:
-------------------------------------------------------
> show GLOBAL variables like 'chara%';
> show SESSION variables like 'chara%';
> status