Backslash inserted before apostrophe
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
Subject
Views
Written By
Posted
Backslash inserted before apostrophe
2743
March 13, 2013 01:27AM
1181
March 13, 2013 09:20PM
938
March 14, 2013 02:10AM
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.