MySQL Forums
Forum List  »  MySQL for Excel

Backslash inserted before apostrophe
Posted by: Arnaud Velard
Date: March 13, 2013 01:27AM


I discovered MySQL for Excel last week which is just what I need.

But I have a small problem.

When I edit a table with an expression containing an apostrophe, a backslash is inserted before it.
For example : "Arrêt d'urgence" becomes "Arrêt d\'urgence" in the table after I commit.

I noticed by clicking on Show details in the box validating the operation that the following is executed :
"001: UPDATE `test`.`liste_defauts` SET `LIBEL_DEFAUT`='Arrêt d\\\'urgence variateur' WHERE `ID`=19;"
(Three \ before the ')

Best regards.


Options: ReplyQuote

Written By
Backslash inserted before apostrophe
March 13, 2013 01:27AM

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.