Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 saving chinese, and vietnamese and armenian

Author  Topic 

csphard
Posting Yak Master

113 Posts

Posted - 2008-04-03 : 20:05:52
Can anyone point us to a tutorial or explain how to save data
in languages other than english to sql2000 database.

I see that the field must be nvarchar or ntext but do not understand
unicode.



Howard

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-03 : 23:16:18
That's correct, unicode is the way to go. Books online has samples.
Go to Top of Page

csphard
Posting Yak Master

113 Posts

Posted - 2008-04-09 : 13:26:10
Hi I created the following table
CREATE TABLE [myTest] (
[test] [nvarchar] (1000) COLLATE Traditional_Spanish_BIN NULL
) ON [PRIMARY]
GO

try to insert chinese using
insert into myTest(test) values (N'?????? ???')

the data in query analyzer display boxes instead of the language like it does here. What am I doing wrong.
Howard



Go to Top of Page
   

- Advertisement -