MySQL Forums
Forum List  »  MySQL for Excel

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

Hello.

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.

Arnaud

Options: ReplyQuote


Subject
Views
Written By
Posted
Backslash inserted before apostrophe
2735
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.