touchsquid Active Member Licensed User Longtime User Feb 10, 2011 #1 I created an Excel spreadsheet with text in it, then imported it into an SQLite via a csv file. French and Spanish characters with accents did not come in correctly. For instance: Enregistreur vidéo became Enregistreur vid�o I can Open the CSV in notepad and the characters show correctly. Encoding of the database is set to UTF-8 (the default). Should this be different? :sign0104:
I created an Excel spreadsheet with text in it, then imported it into an SQLite via a csv file. French and Spanish characters with accents did not come in correctly. For instance: Enregistreur vidéo became Enregistreur vid�o I can Open the CSV in notepad and the characters show correctly. Encoding of the database is set to UTF-8 (the default). Should this be different? :sign0104:
agraham Expert Licensed User Longtime User Feb 10, 2011 #2 Probably the csv file was not in UTF-8 format. Upvote 0
klaus Expert Licensed User Longtime User Feb 10, 2011 #3 Unfortunately when Excel saves a csv file, it is encoded with the ANSI code. What you can do is to load your csv file with notepad and save it with UTF-8 encoding. Best regards. Upvote 0
Unfortunately when Excel saves a csv file, it is encoded with the ANSI code. What you can do is to load your csv file with notepad and save it with UTF-8 encoding. Best regards.
touchsquid Active Member Licensed User Longtime User Feb 10, 2011 #4 Thanks Klaus, that worked. Upvote 0