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]
-----------------------------------------------------------------------------
