CODEWITHSUNDEEP
sql-server-2005collation
Hackworth
Hackworth

Reputation: 1109

Unicode collation for SQL Server 2005?

I need a collation for a database that correctly stores any Unicode character in a SQL Server 2005 instance. The column currently is of type nvarchar (can be changed). How can I do that?

Upvotes: 0

Views: 1057

Answers (1)

Oleg Dok
Oleg Dok

Reputation: 21776

Collation has no connection to storage of N[VAR]CHAR data - it states the rules of comparison between strings. So - you made the right choice - NVARCHAR

Upvotes: 2

Related Questions