-----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)) ... (The casting doesn't actually make any difference but at least shows your intentions). Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkj+Kf0ACgkQmOOfHg372QQg2wCcC2ngZk6u8gU+h4EiU3K7IzoQ MuYAoJ/EspfvUNP9B7fHxaouaLXe5yqy =htIn -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users