French characters (accent) displaying as symbols

Hello Friends,

We are currently facing issues with uploading of data which french accent caracters

Cedilla (ç)
Acute accent (é)
Circumflex (â, ê, î, ô, û)
Grave accent (à, è, ù)
Trema (ë, ï, ü)

The accents are converted into strange symbols which should not be the case.

How do we overcome this issue.

Thanks

Find more posts tagged with

Accepted answers

All comments

Dorra Ben Hmida

Hi @Khaleelah, are you using Board in french ?

No we are not but we have both data french and english

Bettina Clausen

Hi,

are you loading from txt files? If so did you check the encoding of the file itself and the setting in the datareader?

Kind regards,
Bettina

Dorra Ben Hmida

Hi @Khaleelah, how are you uploading your data ? is it by the smart import feature ?

Hi Friends,

Uploading csv / json file through data reader

Dorra Ben Hmida

Hi @Khaleelah , I've tested with the example below and it works correctly :

here is my csv file type:

and the the file options of my Data Reader :

Could you please check these details ?

Thanks.

what if it is a json file?

Dorra Ben Hmida

as far as I know, json file can not be read

Its a call from an API, so the response is Json. But the result is being saved in CSV format.

Hello Khaleelah, I also work in French. You may try to modify the data encoding from utf-8 to Windows-1252 and see what you get. It already helped me a lot!

I hope that helps.

Best regards,

Lucas Charello

Hi Lucas,

Exactly the problem was with the encoding. Now its working.

Thanks for your reply.

Rgds

Khaleelah

Quick Links