Hello, 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? The dynamic typing should look at the data content and not the literal form. So i would consider this a bug. For convenience i tried to always use hex quotes no matter what data is inside. But this is bad for a GUI Frontend i've written which is displaying data differently if 'sqlite3_column_type' returns 4. -- Best regards, Lothar Scholz mailto:[EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------