>From: ?? [mailto:tyzhaoqi@stripped]
>Sent: Thursday, April 21, 2011 7:09 AM
>Subject: mysql deal with specail character problem
>I have a table that the field a is primary key;
>I insert a record like this
>insert into table(a,b,c) values('?????',1,1)
>Then i insert a record like this
> insert into table(a,b,c) values('?????',1,1)
>mysql post a error execute failed: Duplicate entry '?????-1-1' for key 1;
>it is strange, the primary key field is not the same, but i get this error.
>any one can help me?
[JS] What is the character set and collation for that field? Please post the
SHOW CREATE TABLE x\G
(Please use the \G, so that the output will fit in your message better.)
There is something wrong with the way your data is going in, because the
commas are not being seen properly. You are putting in
but MySQL is showing
in the error message! That is a clue.
I have put plenty of Japanese and Chinese characters into my database, so
don't give up hope.