Hi Teg, Can u please send me the sample code
Thanks in advance With Regards, SHIVSHANKER S. HCL Technologies Limited, Chennai-600058 Tel: +91-44-43935000 Extn-5029 Mobile-9884656906 Email: [EMAIL PROTECTED] -----Original Message----- From: Teg [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 3:26 AM To: Shivshankar Subramani - TLS , Chennai Subject: Re[2]: [sqlite] Re: Re: Handling null characters in blob data Hello Chennai, Tuesday, November 14, 2006, 9:20:10 AM, you wrote: SSTC> Hi, SSTC> Actually im trying to store a compressed value,which has lots of SSTC> null characters.When I try to store it into the database as a blob SSTC> item ,only the characters before null gets stored rest does not.I SSTC> want to store the entire compressed buffer. Is it possible? SSTC> BLOB Data stored in the table ->PK... SSTC> Expected data to be stored SSTC> PK..... SSTC> ...Æn5 SSTC> n»(tm)g.. SSTC> .è..... SSTC> ..simpl SSTC> e.datUT SSTC> ...û.ZE SSTC> û.ZEû.Z SSTC> Eí'KNÃ0 SSTC> .?S6Hoe SSTC> Eå}ã.6U SSTC> "¤B¨HHå SSTC> !õ..6n2 SSTC> ¤-.ÇÄN" SSTC> r..ì8DO SSTC> .â.E¤Í£ SSTC> [EMAIL PROTECTED] SSTC> è÷÷..« SSTC> Y.¬½EURHÒ SSTC> Û¨«.¨. SSTC> Ü.=Ê}.M SSTC> Æg.ê;. SSTC> .-fº|lg SSTC> p-®N®; SSTC> Shivshankar Subramani - TLS , Chennai SSTC> <[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 SSTC> [snip] >> Where there are lots of null character in the buffer the sqlite fails >> to take them as values SSTC> What makes you think so? Exactly what are you doing, what results SSTC> do you expect, what results do you get, and how the two differ? SSTC> Igor Tandetnik SSTC> ---------------------------------------------------------------------------- SSTC> - SSTC> To unsubscribe, send email to SSTC> [EMAIL PROTECTED] SSTC> ---------------------------------------------------------------------------- SSTC> - SSTC> DISCLAIMER SSTC> The contents of this e-mail and any attachment(s) are SSTC> confidential and intended for the SSTC> named recipient(s) only. It shall not attach any SSTC> liability on the originator or HCL or its SSTC> affiliates. Any views or opinions presented in this email SSTC> are solely those of the author and SSTC> may not necessarily reflect the opinions of HCL or its SSTC> affiliates. Any form of reproduction, SSTC> dissemination, copying, disclosure, modification, SSTC> distribution and / or publication of this SSTC> message without the prior written consent of the author of this e-mail is strictly SSTC> prohibited. If you have received this email in error SSTC> please delete it and notify the sender SSTC> immediately. Before opening any mail and attachments SSTC> please check them for viruses and SSTC> defect. SSTC> ---------------------------------------------------------------------------- - SSTC> To unsubscribe, send email to SSTC> [EMAIL PROTECTED] SSTC> ---------------------------------------------------------------------------- - I store JPG files in Sqlite DB's without any issues. You can't treat them like text though which is what it sounds like you're doing. You really have two choices, encode them as text using something like UU, Mime or Sqlite's built in encoding or used the advanced API calls to bind the binary data as blobs when inserting and retrieving them using the same mechanism. I use the later, compile the query with parameters and bind the blobs of binary data after the fact before I insert. It's all in the API documents. I can send you sample code if you wish. -- Best regards, Teg mailto:[EMAIL PROTECTED] ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
