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.


Comments

Popular posts from this blog

php - Dynamic url re-writing using htaccess -

java - Multi-Label Document Classification -

blackberry 10 - how to add multiple markers on the google map just by url? -