Setting up SQL Server 7 to accept Chinese characters

[ChrisN]

I know how to set up SQL server, however when I try to set it up to allow chinese characters in field values I always get the characters replaced by ?'s.

Please can someone out there help me?

Thanks in advance.

Chris

 

[wushutwist]

What is the type for the columns? It needs to be either nvarchar or ntext. Also look at the code that is being used to display the data, your problem may not be with storing the data. Wushutwist

 

[ChrisN]

Wushutwist,

I have set up a table and with a column type of nvarchar. When I enter text using Chinese character sets, like I said before, they change to ?'s.

I do not understand what you mean about looking at the 'code' that is being used to display the data.

Please could you/someone provide some more information on this.

Thanks again,
Chris

 

[wushutwist]

When you view the data with the SQL Server tools it will only show as ?????. It is really the Chinese characters, the tool just can't show them.

Do a test. Insert some Chinese Text. Select that text and display it in a tool that supports the type of encoding you need (ex. Web Browser). Wushutwist

 

[wushutwist]

It could also be the drivers you are using to insert the data. What are you using? I only ask because I went thru this same problem and it ended up being the version of the JDBC driver we had for SQL Server. Wushutwist

 

[aalmeida]

have you checked that the codepage you are using is the correct one on all tiers? AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[MinAmiChief]

Depends on your front end?

I have a similar problem with Japanese characters. test it out using the latest downloads of the SQL ODBC driver MS Jet Engine 4.0 and MDAC drivers.

Also make sure the machine that you enter the data in on is the machine you view the data.

1. ODBC driver version 1997 Japanese Characters no dynamic updates
2. ODBC driver version 1999 no Japanese Characters yet dynamic client updates
3. ODBC driver version 2000. Both. Updateable Access 97 linked table with Japanese characters.


Try it out!
Be the change that you want to see in the world - Mahatma Gandhi