We're trying to communicate between NAV 2009 R2 and Oracle database using Linked Server of SQL Server.
As the result, data have been copied from Oracle database to NAV database, but Chinese(Taiwan) letter have changed to "??????".
I think this caused by collation setting issue, current collation settings are below:
SQL Server database: "SQL_1xCompat_CP850_CI_AS"
Linked Server: "SQL_1xCompat_CP850_CI_AS"
NAV : Caseless 3.4.1 database sort order, case-insensitive, accent-sensitive (49) [Code Page Mismatch]
Please tell me your recommended collation settings.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13