>i have a csv file with accentued characters and i suppose its UTF-8 encoded.
>i create a cursor and append this csv file in it with this command:
>
>append from filename.csv type csv
>
>i have a problem wit accentued characters as : "vidéos" transformed in vfp as "vidéos"
>is there a clause i missed to have same fields? even adding codepage (as 1252) this dont solve."set nocptrans fieldname.." also dont solve the problem.
You need to use strconv() twice. Don't have an example at hand, but here's the opposite:
lcText=STRCONV(lcText, 1)
lcText=STRCONV(lcText, 9, nCSVCodePage,1)
So do this in opposite order and with inverse functions of 1 and 9, whatever they are. Filetostr() before and strtofile() after and you should have the csv in your codepage.