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. 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
