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

Hi Shuichi Tamagawa ,

What is the result of SELECT VERSION() ?

What is the result of SHOW CREATE TABLE ?

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 '%шка%'


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.