Read Germany text from file when NAV language is English

kriau
kriau Member Posts: 6
Hello all,

I need to import some Germany contact information from text file. The file is simple single byte csv file. By design, I need to read file programaticaly, I cannot use dataports. The code looks like below:

ImportFile.WRITEMODE(FALSE);
ImportFile.TEXTMODE(TRUE);
ImportFile.OPEN(FileName);
ImportFile.CREATEINSTREAM(InS);
BytesRead := InS.READTEXT(Buffer, MaxRead);

One of the street name in file is "Dweerblöcken", however when read this text into Buffer then actual value what Buffer holds is "Dweerbl÷cken", and this value goes to database. If I type Dweerblöcken into field directly using NAV then value stores correct. Why READTEXT converts specific Germany characters? What I'm doing wrong?

I use English (United States) NAV language, SQL Server 2008, Database Locale is set to Windows Collation "Afrikaans, Basque, Catalan, Dutch, English, Faeroese, German, Indonesian, Italian, Portuguese"

Any ideas?

Regards,
Arturas

Answers

  • fitol
    fitol Member Posts: 46
    NAV uses ASCII internally.
    Your text file probably contains ANSI characters.
    You have 2 options:
    1. Make sure the file is in ASCII.
    2. When you read from the ANSI file you must convert from ANSI to ASCII. There are examples in the Downloads section how to do this.
  • kriau
    kriau Member Posts: 6
    Thanks.

    Has been coverted from ansi to ascii.

    The problem has been solved. :thumbsup: