On 11/15/06, John Stanton <[EMAIL PROTECTED]> wrote:
Vivien Malerba wrote: > On 11/13/06, Shivshankar Subramani - TLS , Chennai <[EMAIL PROTECTED]> > wrote: > >> Hi all, >> >> > SQLite version 2.8 and earlier could not (easily) store binary >> > data - data with embedded \000 characters. Thus the encode/decode >> > routines were provide to transform data so that it contained no >> > \000 characters. >> > >> > SQLite version 3.0 can store binary data without difficulty. >> >> This is what I read in the site >> <http://www.mail-archive.com/sqlite-users@sqlite.org/msg04332.html> >> http://www.mail-archive.com/sqlite-users@sqlite.org/msg04332.html >> ..... but >> i am having difficulty in storing data with null characters in it.Is >> there >> any specific method in which i can solve this problem????? >> > > I personally use the X'AABBCCDD' syntax to store BLOBS where AABBCCDD > is the hexadecimal representation of my binary data (one byte > translated into ist 2 digits hexa equivalent). for example: > "insert into mytable values (1, X'AABBCCDD');" > > Regards, > > Vivien > > ----------------------------------------------------------------------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > That is exapnsion, not compression!
It's just a notation, I believe SQLite does the conversion the other way and stores the BLOB as a binary chunck. Vivien ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------