The method I wrote about earlier is part of a language binding.
I can show you the code if you are interested.
Andy Ross wrote:
Dennis Cote wrote:
> The following log shows that sqlite does indeed distinguish
> between a text field and a blob with the same content. It also
> shows you a workaround. You simply need to cast your fields to
> blobs before you compare them to a variable that is bound to a
> blob.
But I can't do that. I'm writing a language binding, not an
application*, so changes to the query text are outside the realm
of what I can play with. But the fact that it exists is actually
really helpful, because I can just write it into the docs as a
known gotcha without chucking my design entirely, and especially
because it focuses my earlier question better:
If [1] SQLite automatically casts between types as needed in most
cases (e.g. real to/from string) and [2] the cast() syntax
already works to convert between strings and blobs in
the "obvious" way, then: why is the cast automatic for numberic
values, but not for strings/blobs? Isn't that a
non-orthogonality design flaw?
Andy
* ..er, well, I'm writing a language binding *and* an app at the
moment. But I'm much more concerned about the problems with
the bindings. As I mentioned earlier, I can already work
around the issue by making sure all columns that will be
queried with parameters are specified as blobs.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------