HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlModerate

SQL Server 2005/2008 UTF-8 Collation/Charset

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
2008utfsql2005collationservercharset

Problem

I can't find option(s) directly to set UTF-8 rellated Collations/Charsets in SQL Server 2005/2008, same as is possible to set in another SQL engines, but in SQL Server 2005/2008 are there only Latin and SQL collations.

Is there some option to force/install these collations / charsets in SQL Server engine (for both ver.) 2005/2008 on Win2008 OS

Solution

No, there isn't. SQL Server doesn't support UTF-8.

You need to define your columns as nvarchar/nchar if you want unicode data. Note, internally SQL Server stores this as UCS-2.

Note that this has ben requested from MS on Connect and there is an older KB article. And some info on this blog too

Context

StackExchange Database Administrators Q#7346, answer score: 15

Revisions (0)

No revisions yet.