Replace encoding UTF 8 by UTF 7

[EdQas]

:sign0085:
I have a CSV file encoded in UTF 7 (french specifications, like : Président). When i open the CSV (loadcsv), it looks be encoded in UTF8 (english specifications : no accent, like : Prsident).
How can i do to open my file saved in UTF 7 ?

Thank you very much for your help.

Have a nice sunday on our beautiful earth.

 

[Erel]

UTF8 does support these characters.
The problem is probably because of different standards between UTF7 and UTF8.
Do you need to convert it once or many times?
Can you upload this file (or a part of it)?

 

[EdQas]

Hi Erel,
Yes, i can upload without any problem my csv.

Here's a example :
In Excel (or notepad) : dépense effectuée au profit de la collectivité

once uploaded in a combobox : dpense effectue au profit de la collectivit

I'll have to convert it many times. The csv file is updated by many desktops. In my project, i would want to update the csv file in my ppc once a week.



What do you think about this Doctor ?

 

[Erel]

First note that Excel saves CSV files encoded with ASCII which means it will remove all the special characters.
If you are working with Notepad you should use Save As... - Encoding - UTF8.
Attached is a small example.
Please upload the csv file (so I could see the encoding).

 

[EdQas]

Many thanks for your help Erel !

Here's a file made by Excel with 3 rows.

Attention, in fact, my file is a .rar file, not a .zip file !
tks

 

[Erel]

As I wrote Excel doesn't save the file in a proper encoding.
I guess that you see it right on your computer.
This is how I see it:


It probably shows some characters with the computer's default settings.
If you create the file with Notepad and save it as UTF8 it will work properly.

 

[EdQas]

Thank you very much Erel !
Using a "really" text editor (notepad++), i could see that M$ Excel wasn't so good to update my CSV file for my app' !!

Ed