Hi Igor Tandetnik, 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 PK..... ...¸Zn5 >À~Õe.. .è..... ..simpl e.datUT ...¨¦YE ¨¦YE¨¦Y í'KNÃ0 .?S6Hoe *}ã.6U..
Where there are lots of null character in the buffer the sqlite fails to take them as values and hence im having difficulty in storing this kind of buffer. With Regards, SHIVSHANKER S. HCL Technologies Limited, Chennai-600058 Tel: +91-44-43935000 Extn-5029 Mobile-9884656906 Email: [EMAIL PROTECTED] -----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Monday, November 13, 2006 10:00 PM To: SQLite Subject: [sqlite] Re: Handling null characters in blob data 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/[EMAIL PROTECTED] > c.gmane.org/msg04332.html> > http://www.mail-archive.com/[EMAIL PROTECTED] .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????? Use a parameterized query, e.g. update tablename set blobfield=:blob where id=:id Use sqlite3_prepare / sqlite3_step / sqlite3_finalize to execute such a query. Use sqlite3_bind_blob to bind a binary buffer to BLOB parameter. 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] -----------------------------------------------------------------------------
