xml - How to escape ' (apostrophe) in mysql? -

when reading text xml , putting database getting error if text contains '(apostrophe) . how overcome problem while inserting db.

where ever apostrophe add \ (backslash) before it. using text editor find , replace ' \' should work. careful not mess xml structure.

ex.

john's

needs be

john\'s

you can use php or c# escape also. here php function.