"SQLSTATE[HY000]: General error: 1 ESCAPE expression must be a single character" with SQLite [#671348]

Patch originally from http://drupal.org/node/654662#comment-2407998 with minor clean-up. Not familiar enough with DBTNG at this point to know if it really makes sense, but it does fix the issue.

Now, about MySQL…

Comment	File	Size	Author
	sqlite-database-d7.patch	761 bytes	Garrett Albright

Comments

Comment #1

Crell commented 2 January 2010 at 21:00

It looks like the right syntax, but I defer to chx and DamZ on whether or not it's the right fix for SQLite.

Comment #2

backwardgraphics commented 2 January 2010 at 21:19

I can confirm this was an error for me also. The patch fixed it.

Thanks,

Jonny
Web Developer
JonnyTDesigns
Email Me
www.jonnytdesigns.com

Comment #3

Scunt commented 5 January 2010 at 20:59

Also fixed,

Thanks

Comment #4

chx commented 5 January 2010 at 22:36

Status:

Needs review

» Reviewed & tested by the community

If the optional ESCAPE clause is present, then the expression following the ESCAPE keyword must evaluate to a string consisting of a single character. This character may be used in the LIKE pattern to include literal percent or underscore characters. The escape character followed by a percent symbol, underscore or itself matches a literal percent symbol, underscore or escape character in the string, respectively.

So as we are using \ as the escape since the isuse linked in the original, this is right.