Gilles Ganault <gilles.gana...@free.fr> wrote: > After importing DBF files into SQLite, it looks like data are in > Unicode
Actually, it doesn't look like Unicode, but rather some ANSI codepage (my guess would be 1252, Western European). Show the output of this statement: select hex(name) from varmod_stent2010 limit 5; where 'name' is the name of the third column, the one with long text. You need to convert the text to UTF-8 before inserting it into SQLite. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
