SQL2008 R2 – Whats New – Unicode Compression

Digging into SQL Server 2008 R2 there is very little in
the engine that has changed.

One great feature is unicode compression. So if you use nvarchar(n) and
nchar(n) you can save lots of space.

From books online, most european langauges you will save 50% space.

From books online

"Unicode compression in SQL Server 2008 R2 uses an implementation of the
Standard Compression Scheme for Unicode (SCSU) algorithm to compress Unicode
values that are stored in row or page compressed objects. For these compressed
objects, Unicode compression is automatic for nchar(n) and
nvarchar(n) columns. The SQL Server Database Engine stores Unicode data
as 2 bytes, regardless of locale. This is known as UCS-2 encoding. For some
locales, the implementation of SCSU compression in SQL Server 2008 R2 can save
up to 50 percent in storage space"

Locale

Compression
percent

English

50%

German

50%

Hindi

50%

Turkish

48%

Vietnamese

39%

Japanese

15%


Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>