Re: Can't select/inserting/updating some Chinese Character.

[Leung Data]

Hi Shuichi Tamagawa ,
What is the result of SELECT VERSION() ?
4.1.7-standard

What is the result of SHOW CREATE TABLE ?
{error}

What is the result of SHOW VARIABLES LIKE 'CHAR%' ?
+--------------------------+---------------------------------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql-standard-4.1.7-pc-linux-i686/share/mysql/charsets/ |
+--------------------------+---------------------------------------------------------------------+

What kind of program did you use for SELECT/INSERT/UPDATE operation ?
VB, Java (serlvert), or even console manager (eg. MySQL Control Center 0.9.4-beta


Another question is when selecting the record for some chinese using "LIKE", it couldn't return erorr,
eg. Select * from ABCTable where vABC like '%誠%'


Many thanks for your help .