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]/msg04332.html>
http://www.mail-archive.com/[EMAIL PROTECTED]/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]
-----------------------------------------------------------------------------
