You are making an error in the way you handle the compressed data in your program and pass it to the Sqlite API. Read up on the Sqlite API and it will be clear.

Basically if you are handling a buffer of binary data you identify it by a descriptor of some sort, a pointer and a length. If you treat it as test in a null terminated string you will not succeed.

Shivshankar Subramani - TLS , Chennai wrote:
Hi,

Actually im trying to store a compressed value,which has lots of null
characters.When I try to store it into the database as a blob item ,only the
characters before null gets stored rest does not.I want to store the entire
compressed buffer.
Is it possible?

BLOB Data stored in the table ->PK...

Expected data to be stored
  PK.....
  ...�n5
  n�»(tm)g..
  .è.....
  ..simpl
  e.datUT
  ...û.ZE
  û.ZEû.Z
  Eí'KNÃ0
  .?S6Hoe�
  Eå}ã.6U
  "¤B¨HHå
  !õ..6n2
  ¤-.ÇÄN"
  r..ì8DO
  .â.E¤Í£
  [EMAIL PROTECTED]
  è÷÷�..«
  Y.¬½EURHÒ
  �Û¨«.¨.
  Ü.=Ê}.M
  Æg�.ê;.
  .-fº|lg
  p-�®N®;






Shivshankar Subramani - TLS , Chennai
<[EMAIL PROTECTED]> wrote:

I did follow the procedure to store the blob data.I have no problem in excuting it but my problem is that when my data is of the below type in memory


[snip]


Where there are lots of null character in the buffer the sqlite fails to take them as values


What makes you think so? Exactly what are you doing, what results do you expect, what results do you get, and how the two differ?

Igor Tandetnik

----------------------------------------------------------------------------
-
To unsubscribe, send email to [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.

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



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

Reply via email to