Problems importing in UTF-8, displaying French, Arabic and other characters

đź’¬ General Discussion
1

Hello all,

We are facing an issue when importing CSV files. French characters e.g. é, è, ô, arabic characters, etc. are not displaying properly.

From what we can see we have selected “UTF-8” in import’s steps, “UTF8” for imports/exports,and “utf8_general_ci” as Database Collation.

Also, we have installed french language package to check if this could resolve the issue but nothing changes.

Thank you in advance,

Pagibe.

2

When importing, there is a button in the Wizard that opens up a bunch of additional options for the import, like separators and also encodings. Have you tried changing that to match your file?

3

Yes, we have clicked on “View import file properties” button and we have selected UTF-8.
I attach the corresponding image: https://drive.google.com/file/d/1kzvR0ETKBStXsd9JCOkQ87DRjmQ5EwPV/view?usp=sharing

Is this what you mean?
Thank you!

4

Yes, that’s what I meant.

Can you check the encoding of your CSV file? Normally I do this by opening it in Notepad++ where it’s easy to see the current encoding and also to re-encode to something different if necessary.

1 Like