Issues

Select view

Select search mode

 
50 of 62

Database.escapeStringForDatabase for mySQL does not work

Fixed

Description

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 !

Environment

None

Details

Reporter

Components

Fix versions

Affects versions

Priority

Created October 2, 2012 at 2:18 PM
Updated June 20, 2013 at 3:31 AM
Resolved May 23, 2013 at 5:14 PM

Activity

Show:

Nathan Voxland May 23, 2013 at 5:14 PM

Escaping \ chars for mysql now

christophe blin October 2, 2012 at 3:04 PM
Edited

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

Loading...