Hey I guess you should know more of compression algorithm before u call one stupid........
With Regards, SHIVSHANKER S. HCL Technologies Limited, Chennai-600058 Tel: +91-44-43935000 Extn-5029 Mobile-9884656906 Email: [EMAIL PROTECTED] -----Original Message----- From: Gussimulator [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 12:34 PM To: sqlite-users@sqlite.org Subject: Re: Re[2]: [sqlite] Re: Re: Handling null characters in blob data What kind of compression algorithm leaves out null characters? every char will be taking a byte, its just stupid. ----- Original Message ----- From: "Shivshankar Subramani - TLS , Chennai" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Wednesday, November 15, 2006 2:02 AM Subject: RE: Re[2]: [sqlite] Re: Re: Handling null characters in blob data 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 [EMAIL PROTECTED] SSTC> ---------------------------------------------------------------------------- SSTC> - SSTC> DISCLAIMER SSTC> The contents of this e-mail and any attachment(s) are confidential SSTC> and intended for the SSTC> named recipient(s) only. It shall not attach any liability on the SSTC> originator or HCL or its SSTC> affiliates. Any views or opinions presented in this email are SSTC> solely those of the author and SSTC> may not necessarily reflect the opinions of HCL or its affiliates. SSTC> Any form of reproduction, SSTC> dissemination, copying, disclosure, modification, distribution and SSTC> / or publication of this SSTC> message without the prior written consent of the author of this SSTC> e-mail is strictly SSTC> prohibited. If you have received this email in error please delete SSTC> it and notify the sender SSTC> immediately. Before opening any mail and attachments please check SSTC> them for viruses and SSTC> defect. SSTC> ---------------------------------------------------------------------------- - SSTC> To unsubscribe, send email to [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] ---------------------------------------------------------------------------- - ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------