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=""> <strike> <strong>