res...@googlemail.com wrote: > iip schrieb: >> As subject, I want to know how search column that contain ascii chr(0), I >> already use google to search but no luck, > > What about > ... LIKE '%' || X'00' || '%' > or even > ... LIKE X'250025'
Doesn't work. That's the first thing I tried. It seems that the LIKE operator treats NUL character as end-of-string, so the test becomes LIKE '%', which of course matches everything. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users