loadcsv and accent

[claveriel]

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 ?

[Erel]

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.

[claveriel]

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

i 'll work without accent.

thank you for the answer
claveriel

[RandomCoder]

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

Regards,
RandomCoder

[Erel]

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?

[claveriel]

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

[Erel]

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.

[claveriel]

Ok it's good ,

thank you Erel

[yildi]

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

[Erel]

What encoding does your other application use?
If you know the code page you can convert the entire text using two Bitwise objects.
This is the list of code pages: http://msdn2.microsoft.com/en-us/library/ms776446.aspx