MySQL Forums
Forum List  »  MySQL for Excel

Re: escaping special characters in Mysql for excel
Posted by: Javier Treviño
Date: May 05, 2014 02:36PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: escaping special characters in Mysql for excel
2070
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.