Re: [sqlite] Convert data to binary

2011-11-25 Thread Dan Kennedy 

On 11/26/2011 05:02 AM, Nico Williams wrote:

You can CAST TEXT to BLOB, and you can use x'' for literal BLOBs.


You can. The result of which is a blob that corresponds to
either the utf-8 or utf-16 (big or little endian) encoding
of the text, depending on the encoding used by the database
file.

FWIW.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Convert data to binary

2011-11-25 Thread Nico Williams 
You can CAST TEXT to BLOB, and you can use x'' for literal BLOBs.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Convert data to binary

2011-11-25 Thread Carl Desautels 
I'd like to store any data as binary in my sqlite database, I approached
the problem by trying to hex() the input because the x' ' operator accepts
hex and outputs binary, for example:

x'hex("hello world")'

but that syntax doesn't work, is there any way to make storing any data as
its binary value possible?

-- 

Carl
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users