开发者

How import Special Characters from Excel to SQLIte

开发者 https://www.devze.com 2022-12-29 04:16 出处:网络
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).

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

精彩评论

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

关注公众号