SQL Statement to display Big5 - SQL Server Forums

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

New to SQL Server Programming

SQL Statement to display Big5

Author

Topic

NewSQLMember
Starting Member

15 Posts

Posted - 2009-08-21 : 04:45:30

Hi,

Anyone can help, Im in the stage of migration using SqlServer 2005. My database creation having a collation of SQL_Latin1_General_CP1_CI_AS.

TableName : test
Field : test nvarchar(50)

test
----
-1?~¨?à3
?e????°ê

I want these to display a collation of Big5 "Traditional Chinese" using a select statement in command.

Regards,
NSM

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-21 : 04:51:37

ALTER TABLE Test
ALTER COLUMN Test NVARCHAR(50) COLLATE Big5 "Traditional Chinese

N 56°04'39.26"
E 12°55'05.63"

NewSQLMember
Starting Member

15 Posts

Posted - 2009-08-21 : 04:57:41

Getting : Invalid collation 'Big5'.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-21 : 05:27:26

You have to replace the part in red with the collation name you want to use instead.
Maybe it's Chinese_Hong_Kong_Stroke_90_CI_AS ? There are so many chinese collations to choose from.

Also read http://support.microsoft.com/kb/917398

N 56°04'39.26"
E 12°55'05.63"

NewSQLMember
Starting Member

15 Posts

Posted - 2009-08-21 : 06:05:54

Hi Peso,

Try all chinese collation but no luck.

Regards,
Ferdie

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources