Ah! I am invoking sqlite in a "DOS" shell which on my machine uses CP437, just as you say.
Ironically, this turns out to be a blessing. The behavior of my data source changed (I don't have control over it) from a space to a non-breaking space. If I had been using a a more modern codepage, I might not have caught on as soon. Thank you. I'm a little wiser now. Robert Wishlaw wrote: > On 2/16/08, Coatimundi <[EMAIL PROTECTED]> wrote: > >> I hope this questions isn't a FAQ... >> >> I have a tab-delimited text file which I .import using .sep "\t" into a >> freshly declared table whose columns are of type TEXT. >> >> The program which generates the text file exports each "empty" field (if >> any) as a single non-breaking space, i.e. 0xA0. >> >> SQLite 3.5.4 .import's the data which complaining, not surprisingly. >> But the non-breaking space is rendered in SELECT output as a lower-case >> acute-a, aka U+00E1. >> >> > This is a Windows code page problem. Your output data to is being > displayed as CodePage 437 which displays an acute-a for OxA0. For > details see > > http://en.wikipedia.org/wiki/Code_page_437 > > Postgresql also had this output problem but solved it with a patch > discussed around this thread node > > http://archives.postgresql.org/pgsql-hackers-win32/2005-01/msg00227.php > > Robert Wishlaw > > > >> I'm certainly no Unicode expert. I end up doing an UPDATE on each >> column to replace รก with an empty string. >> >> Obviously, I could also preprocess my textfile to remove the 0xA0. But >> can someone help me understand what's going on here? >> >> Thanks! >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users