Problem about single quote
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
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.