"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] -----------------------------------------------------------------------------