List:General Discussion« Previous MessageNext Message »
From:赵琦 Date:April 21 2011 11:09am
Subject:mysql deal with specail character problem
View as plain text  
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?

Thanks

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