Replace encoding UTF 8 by UTF 7

E

EdQas

Member

Licensed User

• Sep 16, 2007

• #1

: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

B4X founder

Staff member

Licensed User

Longtime User

• Sep 16, 2007

• #2

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)?

 

E

EdQas

Member

Licensed User

• Sep 16, 2007

• #3

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

B4X founder

Staff member

Licensed User

Longtime User

• Sep 16, 2007

• #4

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).

 

Attachments

• utf8.zip

  451 bytes · Views: 246

E

EdQas

Member

Licensed User

• Sep 16, 2007

• #5

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

B4X founder

Staff member

Licensed User

Longtime User

• Sep 16, 2007

• #6

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.

 

E

EdQas

Member

Licensed User

• Sep 16, 2007

• #7

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

 

Last edited: Sep 16, 2007