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

Re: mysql deal with specail character problem

thanks for reply! The charater set is latin1,and the key field is mangled by the email client. I up load the actual character of '?' to the attachment. 2011/4/22 Jerry Schwartz je...@gii.co.jp -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent:

replication problem

hi all: I have three mysql database,tow run as master and the other one runs as slave. Some tables in the database have an autoincreament field named as 'rowid'. These tables have 100 records on master, but some of these tables on the slave only have thousands of record. The tables on the