It works in a Linux xterm. There's probably some UTF or codepage issue with the Windows console. Try using another command-line shell.
--- Robert Wishlaw <[EMAIL PROTECTED]> wrote: > 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? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
