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.lang.tcl, it seems that the issue is related to whether or not the Tcl variable in question contains a string representation at the time it's inserted into the BLOB field. If it does contain a string representation, the inserted data is incorrect. If it does not contain a string representation, the inserted data is correct. Not wanting to get into a "Tcl Internals" discussion here, my question is this: 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. I have several potential solutions from the Tcl side, but wanted to explore the possibilities from this side also. Thanks for any input. Jeff Godfrey
