loadcsv and accent

Discussion in 'Questions (Windows Mobile)' started by claveriel, Jun 21, 2007.

  1. claveriel

    claveriel Member

    hello,
    i use the function : Tableinterv.LoadCSV("interv.csv", ";", 0,true)
    to load a csv file in a table, it works but in french we have caracter with accent for exemple : é
    all caracters with accent are ingnored :(

    example: the word été become t.

    can you help me ?
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    LoadCSV does support accent characters (it uses UTF-8 encoding).
    How did you create the CSV file?
    Microsoft Excel doesn't support accent characters when you save CSV files.
     
  3. claveriel

    claveriel Member

    i create myself the csv file, i don't use excel.

    i 'll work without accent.

    thank you for the answer
    claveriel
     
  4. RandomCoder

    RandomCoder Well-Known Member Licensed User

    I think that you could use XML format instead and retain the accent.

    Regards,
    RandomCoder
     
  5. Erel

    Erel Administrator Staff Member Licensed User

    Again, there is no problem to work with accent characters.
    How did you create the CSV file?
    Did you save it encoded with UTF-8?
     
  6. claveriel

    claveriel Member

    To create my csv, i export my data from an other sotfware.
    i want to modify and create datas in the pocket pc. I save the data to a csv file in the pocket.

    After the csv files go to the pc with activesync.
    and i import my data into my other software.

    this en exemple of a c sv file :

    barthe;2004;N;Maïs consommation;10.88
    cousin;2004;N;Maïs consommation;0
    pignada;2004;N;Graines fourragères;60.46
     
    Last edited: Jun 21, 2007
  7. Erel

    Erel Administrator Staff Member Licensed User

    Try to load this file (it is the data you've posted).
    It was created with Notepad and it was saved encoded with UTF-8.
     

    Attached Files:

    • 1.txt
      File size:
      120 bytes
      Views:
      48
  8. claveriel

    claveriel Member

    Ok it's good ,

    thank you Erel
     
  9. yildi

    yildi Member Licensed User

    I have the symmetrical problem: In the small soft I have developed, I save some data using Table.SaveCSV but if I open it in ThinkingRock (which is a Java program), I get garbage (the unicode indicator at the beginning and garbaged accented characters). Is there a way to convert to high ASCII the text saved in the CSV file, instead of UTF8? Or, how can I export data containing accented characters with SaveCSV to a software that does not seem to understand the Unicode?

    Thank you very much in advance.

    Murat
     
  10. Erel

    Erel Administrator Staff Member Licensed User

  11. yildi

    yildi Member Licensed User

    Thanks Erel,

    But I think we are higher than my computing competency here (I am a random coder much more random than RandomCoder ;-) ). I do not know the code page. I am surprised that this program does not understand Unicode, at least for this function... You are of course write (my question is stupid); there is nothing like high ASCII without a corresponding code page...

    I have asked the question at ThinkingRock user forums. We will see if someone has an answer...

    Regards,

    Murat
     
Loading...