MySQL Forums
Forum List  »  Replication

Problem about single quote
Posted by: Joule Cheong
Date: March 17, 2005 10:06PM

Dear all,

I'm a new MySQL user. There are some replication problems which I don't know how to fix it. Hope somebody can help me.
Thank you so much firstly.
My MySQL version is 3.23.58 on Linux Red hat 7.3 platform,
I turn on the DB replication function for two MySQL server data
synchronization. All delta (difference between these 2 servers)
are synchronized successfully except ' (single quote) symbol in
my records. I guess all synchronizing actions will be transferred
to SQL statements finally. If the ' (single quote) symbols are
contained in the synchronizing records, the corresponding SQL
statement will like that:

insert into TableABC values ( 1, 'He's a boy.' );

The statement above doesn't work obviously.

Hope someone know how to solve this problem.

Best regards,

Joule Cheong

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem about single quote
3608
March 17, 2005 10:06PM
2283
March 18, 2005 07:45PM


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.