jason d wrote: > On Mon, Apr 26, 2010 at 11:28 AM, Igor Tandetnik <itandet...@mvps.org>wrote: >> What does this statement return: >> >> select name, hex(name) from Groups >> where name like '%jean%'; >> >> My guess is, you either have leading and/or trailing whitespace around the >> value, or the dash in the middle is not U+002D (HYPHEN-MINUS) but some other >> Unicode character that looks like a dash, e.g. U+2013 (EN DASH). The hex >> dump would tell. >> > this is what I got. I am using SQLite version 2.8.17 > > SQL error: no such function: hex
Well, I don't have the reference for SQLite2, so you'll have to do some investigative work here. Isn't there some way to inspect actual character codes comprising a string? Perhaps you can write a test application to do that. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
