Replace encoding UTF 8 by UTF 7

Discussion in 'Questions (Windows Mobile)' started by EdQas, Sep 16, 2007.

  1. EdQas

    EdQas Member Licensed User

    :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.:)
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    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)?
     
  3. EdQas

    EdQas Member Licensed User

    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 ?
     
  4. Erel

    Erel Administrator Staff Member Licensed User

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

    Attached Files:

    • utf8.zip
      File size:
      451 bytes
      Views:
      30
  5. EdQas

    EdQas Member Licensed User

    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
     
  6. Erel

    Erel Administrator Staff Member Licensed User

    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:
    Picture1.jpg

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

    EdQas Member Licensed User

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