You may try to convert the cvs file by using STRTOFILE(STRCONV(STRCONV(FILETOSTR([cvsfilename],11),2),[cvsfilename]) before appending (it will change from UTF-8 to DBC and then to SBC - of course, something may get lost in translation, but being from a western origin Windows 1252 character encoding will normally be enough).


>I have an app in which CSV files import client data. These CSV files have been in English but are now starting to arrive in French where Entreés shows up as Entrées. These CSV files are saved as UTF-8 by the client's system.
>
>I can't seem to find how to get the file to convert so that the French characters appear as they should. CPCURRENT(1) returns 1252 and CPCURRENT(2) returns 437. I've tried all the codepages in the line of code importing the file:
>
> APPEND FROM [csvfilename] TYPE CSV AS [nCodePage]
>
>but without success. I'm probably missing something stupidly basic, but can't seem to find how to get the file to translate properly. Any ideas?
>
>Many thanks,
>Dave