Navision on Chinese on SQL Server


I have installed Navision runnong on Chinese, with collation of “SQL_1xCompat_CP850_CI_AS”. I have managed to enter information in Chinese from the Navision application However, when these data are viewed from the SQL database, it is gibberish. Therefore when Reporting services is deployed for the database, the characters are not displayed correctly.

Help is very much appreciated.


We have also the chinese caractere in my installation. Have you try to change the Langage for non unicode programs to Chinese (taiwan) on your AOS server (+SQL?) ? It is under Langage and Regional settings.

However if you have some French, Spanish or other special caracteres, you may encouter different problems like having some chinese kanji instead of your caractere…


Moved to SQL Forum.