Re: escaping special characters in Mysql for excel
Hi Ludwig,
Thanks for writing in our forums!
I believe what you found is a bug but to confirm, can you please turn on the global option to preview the SQL queries before they are sent to the database?? That option was introduced in MySQL for Excel 1.2.0.
If you preview the SQL queries you will be able to workaround the issue by editing the SQL query before sending it to the MySQL server and escaping yourself the special characters.
If you find out the generated SQL query is indeed not escaping special characters as it should then please raise a bug for MySQL for Excel at:
http://bugs.mysql.com
Thanks for the feedback, it helps us improve our products!
Best regards.
====================================
Javier Treviño
MySQL on Windows Team
Subject
Views
Written By
Posted
3013
April 24, 2014 01:38PM
Re: escaping special characters in Mysql for excel
2138
May 05, 2014 02:36PM
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.