On Tue, Jun 28, 2011 at 7:24 AM, Gilles Ganault <gilles.gana...@free.fr>wrote:
> Hello > > After importing DBF files into SQLite, it looks like data are in > Unicode, so I get funny characters when running sqlite3.exe in a DOS > box on Windows: > SQLite uses only unicode (utf8 by default, but it also works with utf16). Probably your DBF file was exported as MBCS. You need to convert the MBCS from the export into utf8 or utf16 prior to import into SQLite. > > sqlite> select * from varmod_stent2010 limit 5; > A10|BE|Industrie manufacturiFre, industries extractives et autres > A10|FZ|Construction > A10|GI|Commerce de gros et de dTtail, transports, hTbergement et > restauration > A10|JZ|Information et communication > A10|KZ|ActivitTs financiFres et d'assurance > > I typed ".help", but it doesn't seem to include a way to change the > character set. Is there a solution within sqlite3.exe, or is the only > way to write a quick PHP script? > > Thank you. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
