Importing special characters with XMLport in Nav4.03

Naj

Hello,

I am importing XML files which are utf-8 encoded into my database and creating customer records from it.
Now city can be for example Munich, which in german is München. In the XML the 'ü' is in utf-8 notation the two characters C3 BC. When i import this, the XMLport writes München into the table.
If I modify the XML to send the ü, which is not in line with utf-8, then it writes München correctly into the table.
When i export a record with München with a XMLPort however, it encodes the special characters correctly. (e.g. ü -> C3 BC).

Is there a way to force the XMLPort to do it correctly when importing also?

Thanks and best regards

Naj

Hi,

Anyone have an idea?

How does Navision determine what codepage to use?
Is it based on windows language settings? Or navision client language? Or SQL settings? How about native if it's the latter case?

Thanks

ara3n

It is based on Windows Regional and Language Options.