How import Special Characters from Excel to SQLIte

Question

I try to import an Excel table with German special characters (ä, ö, ü, ß, Ä, Ö, Ü). These don't import properly into the SQLite database (using the firefox SQLite Manager).

Any clues how to properly import the CSV file?

Answer 1

Are you properly formatting your strings as UTF8?

Answer 2

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.