List:General Discussion« Previous MessageNext Message »
From:Steve Staples Date:April 21 2011 1:48pm
Subject:RE: mysql deal with specail character problem
View as plain text  
On Thu, 2011-04-21 at 09:35 -0400, Jerry Schwartz wrote:
> >-----Original Message-----
> >From: ?? [mailto:tyzhaoqi@stripped]
> >Sent: Thursday, April 21, 2011 7:09 AM
> >To: mysql
> >Subject: mysql deal with specail character problem
> >
> >Hi:
> >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 
> output of
> 
> 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
> 
> '?????',1,1
> 
> but MySQL is showing
> 
> '?????-1-1'
> 
> 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.
> 
> >Thanks

Doesn't the '?????-1-1'  mean that it's a joined key?  so the 3 fields
he's inserting, are part of a multi-field key... but to me, it looks
like the characters are not being seen, or converted to a UTF-8 style
format, rather than the chinese (korean/japanese) character set.. ?
maybe?

sorry if i am out of line here... 

Steve.



Thread
mysql deal with specail character problem赵琦21 Apr
  • Re: mysql deal with specail character problemJohan De Meersman21 Apr
  • RE: mysql deal with specail character problemJerry Schwartz21 Apr
    • RE: mysql deal with specail character problemMartin Gainty21 Apr
    • RE: mysql deal with specail character problemSteve Staples21 Apr
      • Re: mysql deal with specail character problemJohan De Meersman21 Apr
        • RE: mysql deal with specail character problemJerry Schwartz21 Apr
          • Re: mysql deal with specail character problem赵琦22 Apr
            • RE: mysql deal with specail character problemJerry Schwartz25 Apr