Re: [sqlite] Handling null characters in blob data

[Vivien Malerba]

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

Re: [sqlite] Handling null characters in blob data

[John Stanton]

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  
. 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!

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Handling null characters in blob data

[Vivien Malerba]

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

[sqlite] Handling null characters in blob data

[Shivshankar Subramani - TLS , Chennai]

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  . 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?
 
Thanks in advance
 

With Regards,


SHIVSHANKER S.


HCL Technologies Limited,  

Chennai-600058
Tel: +91-44-43935000 

Extn-5029 Mobile-9884656906
Email: [EMAIL PROTECTED]  

 
DISCLAIMER 
The contents of this e-mail and any attachment(s) are confidential and intended 
for the 

named recipient(s) only. It shall not attach any liability on the originator or 
HCL or its 

affiliates. Any views or opinions presented in this email are solely those of 
the author and 

may not necessarily reflect the opinions of HCL or its affiliates. Any form of 
reproduction, 

dissemination, copying, disclosure, modification, distribution and / or 
publication of this 

message without the prior written consent of the author of this e-mail is 
strictly 

prohibited. If you have received this email in error please delete it and 
notify the sender 

immediately. Before opening any mail and attachments please check them for 
viruses and 

defect.