Interesting. That sounds like exactly what I need. I'm curious, did
the patch somehow arise from my query, or is the timing of the query
and the patch just coincidental?
Also, how soon would you expect this patch to make it into an
"official build"? I've never built SQLite from the sources before,
and don't really have the time to work through the details right now.
Thank you.
Jeff Godfrey
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, June 19, 2007 12:17 PM
Subject: Re: [sqlite] Tcl and BLOB data
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote:
Is there a way I can "force" SQLite to insert my data as a BLOB,
even if the containing variable has a string representation? I
tried to CAST the data to a BLOB during the insert, but the results
were the same.
If you get the patch I just checked in
http://www.sqlite.org/cvstrac/chngview?cn=4092
and if you use a "@" character instead of "$" in front of the
variable name, and the variable has a bytearray representation,
then the variable will be bound as a BLOB even if the variable
also has a text representation.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
