Database.escapeStringForDatabase for mySQL does not work
Description
Environment
None
Activity
Show:
Nathan Voxland May 23, 2013 at 5:14 PM
Escaping \ chars for mysql now
christophe blin October 2, 2012 at 3:04 PMEdited
Finally I've found a workaround : use sessionVariables=storage_engine=InnoDB,sql_mode=NO_BACKSLASH_ESCAPES inside jdbc url
Of course, if you are not using innodb only add sql_mode
Under mysql, the antislash is an escaping char (http://dev.mysql.com/doc/refman/5.0/fr/string-syntax.html)
So this test should pass and currently fails :
For now, I'm stuck with 1.9.5 and I did not find any workaround.
If you have one, thanks to share !