开发者

How import Special Characters from Excel to SQLIte

I try to import an Excel table with German special characters (ä, ö, ü, ß, Ä, Ö, Ü). These don't import properly into the SQLite database (using the f开发者_开发知识库irefox SQLite Manager).

Any clues how to properly import the CSV file?


Best option I found was to save as CSV in Excel and use Windows Notepad to convert it from ANSI to UTF-8, this way I got it imported properly.


Are you properly formatting your strings as UTF8?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜