Lauguage support in SQL server 2005 english ver

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

SQL Server 2005 Forums

Transact-SQL (2005)

Lauguage support in SQL server 2005 english ver

Author

Topic

wangxianlg
Starting Member

2 Posts

Posted - 2008-02-25 : 15:50:08

I created a table in SQL server 2005 english version and one of the column stored the chinese characters using nvarchar(X). There is no problem to store the Chinese characters in that column. The question is how I can retrieve the data based on that column data. For example:

select *
from ChinsesCharaterColumn = 'ChinsesCharacter'

Please help!
Alan

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-25 : 16:15:38

select *
from ChinsesCharaterColumn = N'ChineseCharacter'

E 12°55'05.25"
N 56°04'39.16"