Using sqlite 3.5.2 on Windows XP, I have a textblob.csv file 192,C0,À0,À0 193,C1,Á0,Á0 254,FE,þ0,þ0 255,FF,ÿ0,ÿ0
which I have imported into a new database sqlite3 textblob.db < textblob.sql via a file named textblob.sql .separator , create Table textblob(dec INTEGER, hex BLOB, txt TEXT, blb BLOB); .import 'textblob.csv' textblob When I run the query SELECT dec, hex FROM textblob WHERE blb = 'À0'; there is no result. Likewise SELECT dec, hex FROM textblob WHERE blb = "À0"; does not work. SELECT dec, hex FROM textblob WHERE hex = "C0"; returns 192|C0 Any idea how to get the BLOB data? Or is the problem that the BLOB data is not there because .import is filtering out invalid UTF-8? Robert Wishlaw ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
