Re: Can't select/inserting/updating some Chinese Character.
Posted by: Leung Data
Date: June 17, 2005 03:54AM

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 .

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.