Can not read Chinese data when DB Connect to SQL server 2000

[Former Member]

Hi,

Our BW server( BW3.5 not unicode ) is installed on MS SQL server 2000. We try to connect the BW SQL server with db connect function. We create some test views in the Northwind DB. We are be able to access data from source system in rsa1 by db connect. The problem is that all the Chinese characters are displayed as ?????. Is there any special setting for accessing multibyte characters in MS SQL server 2000? Please advise.

Thank you,

Jeff

[Former Member · Accepted solution]

The field of VIEW in the sqlserver which code is chinese must be the nvarchar.

You can try it.