CODEWITHSUNDEEP
iphonesqlite
user306766
user306766

Reputation:

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 firefox SQLite Manager).

Any clues how to properly import the CSV file?

Upvotes: 0

Views: 2176

Answers (2)

user306766
user306766

Reputation:

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.

Upvotes: 3

Pyro2927
Pyro2927

Reputation: 1112

Are you properly formatting your strings as UTF8?

Upvotes: 0

Related Questions