Hi there,
I have a csv file that I can import into my appery database. The problem is, some of my values include special characters (french) such as Pyrénées or Ribeauvillé. When these characters are imported they are replaced by �.
Can you please tell me how I can import them without this error.
Thanks in advance.
James
Hello,
Could you send us a sample .csv file to a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a?
Hello Jimmy,
Also could you please check the Encoding type for your csv files. It should be UTF-8. You can check it by opening it in the simple text editor.
For example by default Excel saves this format in ANSI and this can provide such errors.
Hi Evgene,
Thanks very much, you gave me the tip I needed. I have fixed the issue. You were right about the default excel format.
So if you are using Excel to build your CSV, these are the steps I followed:
1- Save your Excel CSV as “.CSV” file
2- Open the .CSV again using NOTEPAD
3- Save again with NOTEPAD using the “UTF-8” encoding.
Now the file imported perfectly.
Thanks again!
jimmy