[EMAIL PROTECTED] wrote: >> See if this statement returns any rows. Any whitespace should be >> clearly visible: > >> select '!' || name || '!' from PerfTest1 >> where name != trim(name); > > 0 rows so it's not spaces.
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?) Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
