-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 06/05/2011 12:20 AM, iip wrote: > As subject, I want to know how search column that contain ascii chr(0), I > already use google to search but no luck, > > I'm using python language.
If you are using APSW then you can define a user defined function which will work fine: def hasnull(s): return "\x00" in s This won't work with pysqlite because it doesn't handle nulls in strings. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk3rtsgACgkQmOOfHg372QT5nwCfX0T2jhWWHcHDx9tdd7tZGMVF qfcAoJ8NgSSAno9v3YhIEIzwIpQ9CD5Q =1nqN -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users