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.
> 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:
You should convert you binary data into hex in your programming
language outside SQLite if you want to conc
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
On Nov 25, 2011, at 10:23 PM, Carl Desautels wrote:
> x'hex("hello world")'
sqlite> select x'68656C6C6F20776F726C64';
hello world
x denotes a blob literal:
"BLOB literals are string literals containing hexadecimal data and preceded by
a single "x" or "X" character."
http://www.sqlite.org/lan
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 valu
5 matches
Mail list logo
