[EMAIL PROTECTED] wrote: >> What about this: > >> select name, length(name), hex(name) >> from PerfTest1 >> where name like '%key5000%'; > >> hex(name) should dump raw bytes, in hexadecimal, stored in name >> column. See if there's anything unusual (perhaps a trailing NUL >> byte?) > > Returns: 'key5000'|9|276B65793530303027 > > Nothing weird there.
The text stored in your table contains single quotes. In other words, the string you store is not 'key5000' but '''key5000''' . Note how the length is 9, not the expected 7. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users