Lothar Scholz <scholz-qqUfbLNYxjJCkLs28/[EMAIL PROTECTED]> wrote:
it seems that "Lothar" is stored as a TEXT value but when i store X'4C6F74686172' it is a BLOB. What is the reason for it?
Same reason 1 is an integer literal but '1' is a string literal. X'4C6F74686172' is a blob literal.
The dynamic typing should look at the data content and not the literal form. So i would consider this a bug.
What do you mean, data content? How is it supposed to know that a particular sequence of bytes is supposed to represent a string, without the help of mind-reading hardware? After all, you don't expect the number 48 to be magically interpreted as a string '0'. You don't, right?
For convenience i tried to always use hex quotes no matter what data is inside.
Use parameterized queries and approprite sqlite3_bind_* calls. This way you unambiguously control the type of the value.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------