Re: why client characterset and sever characterset are set to Latin when character set client and server are set to different character set
Posted by: Sam Ohn
Date: November 12, 2010 09:49AM

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

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.