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?
精彩评论