Bug #68669 A backslash is inserted before an apostrophe editing table with MySQL for Excel

• Submitted: 14 Mar 2013 8:07
• Modified: 25 Sep 2013 21:53
• Reporter: Arnaud Velard
• Status: Closed
• Category: MySQL for Windows: MySQL for Excel
• Severity: S3 (Non-critical)
• Version: 1.1.2
• OS: Windows (7 pro)
• CPU Architecture: Any
• Tags: apostrophe, backslash

[14 Mar 2013 8:07] Arnaud Velard

Description:
When a table is edited with MySQL for Excel with a text containing an apostrophe, a backslash is inserted before it.
For exemple, "Arrêt d'urgence" in excel becomes "Arrêt d\'urgence" in the table.

How to repeat:
Edit a table with MySQL for Excel trying to insert an apostrophe in the field : "Arrêt d'urgence" for example.

After commiting, the "Show details" in the confirmation box will show with the example :
####################################################################
Deleting 0, Inserting 0, Updating 1 row(s) with the following SQL statement(s):
001: UPDATE `test`.`liste_defauts` SET `LIBEL_DEFAUT`='Arrêt d\\\'urgence' WHERE `ID`=20;
Deleted 0, Inserted 0, Updated 1 row(s).
####################################################################

Suggested fix:
Modify the sql query to have `LIBEL_DEFAUT`='Arrêt d\'urgence' instead of `LIBEL_DEFAUT`='Arrêt d\\\'urgence'

[14 Mar 2013 9:36] MySQL Verification Team

Thank you for the bug report. Could you please try latest version and comment the result. Thanks.

[29 Apr 2013 15:10] Arnaud Velard

Hello.
I have downloaded the mysql-installer-community-5.6.11.0.msi with MySQL for excel 1.1.1 and installed it.

I still have the apostrophe problem.

Best regards.

[5 Aug 2013 6:29] Arnaud Velard

Hello.
After upgrading with mysql-installer-community-5.6.13.0.msi, the problem still occurs.

Best regards.

Arnaud Velard

[25 Sep 2013 21:53] Philip Olson

Fixed as of MySQL for Excel 1.1.2, and here's the changelog entry:

A backslash was inserted before each apostrophe after performing an "Edit
Data" operation.

Thank you for the bug report.