Roger Binns rogerb-at-rogerbinns.com |Sqlite| wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Evan Burkitt wrote: >> Roger Binns rogerb-at-rogerbinns.com |Sqlite| wrote: >>> select cast(column as blob) >> I'm glad to know this syntax, but no dice. The nulls seem to be >> insurmountable barriers. > > That is due to the sqlite3_exec api used by the shell which returns null > terminated strings for every column and obviously there is no way to > tell the difference between the null being part of or terminating the > string. > > Anyway you can use hex to work around this: > > select hex(cast(column as blob)) ...
Now that does work. Thanks. -evan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users