Re: [sqlite] Tcl and BLOB data

2007-06-19 Thread Jeff Godfrey
Very informative. Thank you. Jeff - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Tuesday, June 19, 2007 8:59 PM Subject: Re: [sqlite] Tcl and BLOB data "Jeff Godfrey" <[EMAIL PROTECTED]> wrote: I don't really understand why, when my data h

Re: [sqlite] Tcl and BLOB data

2007-06-19 Thread drh
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote: > > I don't really understand why, when my data has a binary > representation and I'm trying to place it in a BLOB field, > the string representation is used instead (assuming it exists). > I wrote up a terse explanation on the Tclers wiki. See htt

Re: [sqlite] Tcl and BLOB data

2007-06-19 Thread Jeff Godfrey
- Original Message - From: <[EMAIL PROTECTED]> To: Sent: Tuesday, June 19, 2007 3:43 PM Subject: Re: [sqlite] Tcl and BLOB data I did this change at your request, because it seemed like a good enhancement. Thanks. I agree, it sounds like a good enhancement. Though, I

Re: [sqlite] Tcl and BLOB data

2007-06-19 Thread drh
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote: > 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 > "offici

Re: [sqlite] Tcl and BLOB data

2007-06-19 Thread Jeff Godfrey
ite 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: Sent: Tuesday, June 19, 2007 12:17 PM Subject: Re: [sqlite] Tcl and BLOB data "Jeff Godf

Re: [sqlite] Tcl and BLOB data

2007-06-19 Thread drh
"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 ch

[sqlite] Tcl and BLOB data

2007-06-19 Thread Jeff Godfrey
Hi All, I have an interesting Tcl / SQLite BLOB issue going on that I hope you can help with... I have binary data stored in a Tcl variable that I'm stuffing into SQLite BLOB field. The resulting data in the BLOB field is corrupted. After much experimentation, and help from the folks on comp