How to set up a SQL Server for storing Chinese characters

Any idea what is the set up process is? I've tried a couple of
different character set and it's still not displaying the characters
correctly. I could insert the Chinese characters into a table using
INSERT with no error, but the SELECT statement shows "?"
Thanks for any help in advance.
John
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
John,
Are you using the Unicode datatypes of Nchar, Nvarchar, Ntext to store your
Chinese characters?
Also, you might want to read the MSDN article "International Features in
Microsoft SQL Server 2000" at:
http://msdn.microsoft.com/library/de...Server2000.htm
as it has a lot of info on how to setup and use Chinese characters.
Regards,
John
"John Lee" <john.lee104@.verizon.net> wrote in message
news:#JAsC#3HEHA.3356@.TK2MSFTNGP11.phx.gbl...
> Any idea what is the set up process is? I've tried a couple of
> different character set and it's still not displaying the characters
> correctly. I could insert the Chinese characters into a table using
> INSERT with no error, but the SELECT statement shows "?"
> Thanks for any help in advance.
> John
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Now I'm all set with saving and displaying the data. My next question
is how to script that for setting up a MSDE SQL server.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||If you have access to SQL Server 2000 Standard or Developer Editions (or
above), you can use the Enterprise Manager to "generate SQL scripts" for
your database. If you don't have access to these Editions, there are several
"free" or low-cost "Enterprise Manager-like" tools, such as the following:
TOAD for SQL Server at http://www.toadsoft.com/toadss.html
and Microsoft's new SQL Server Web Data Administrator at:
http://www.microsoft.com/downloads/d...displaylang=en
Regards,
John
"John Lee" <john.lee104@.verizon.net> wrote in message
news:uMLEEBBIEHA.2836@.TK2MSFTNGP11.phx.gbl...
> Now I'm all set with saving and displaying the data. My next question
> is how to script that for setting up a MSDE SQL server.
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!