On Nov 6, 2007 8:55 AM, Joe Wilson [EMAIL PROTECTED] wrote:
It works in a Linux xterm.
There's probably some UTF or codepage issue with the Windows console.
Try using another command-line shell.
Thank you for your response Joe. It is a codepage issue. Using
sqlite3.exe 3.5.2 from a Windows XP
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
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