Schema - Do you only use Unicode datatypes (nchar, nvarchar and ntext) in special circumstances?
Rules To Better SQL Databases - Developers|4e2c5421-72b9-46c2-b5c7-311882ec35fd
v1.0
Posted at
6/11/2019 9:46 AM by
Tiago Araujo
Rule Intro
Columns defined using the nchar, nvarchar and ntext datatypes can store any character defined by the Unicode Standard, which includes all of the characters defined in the various English and Non-English character sets. These datatypes take twice as much storage space per characters as non-Unicode data types.
Page Content
It is not the disk space costs that are the concern. It is the 8060 limit, please refer to Maximum Capacity Specifications for SQL Server for details.
If your database stores only English characters, this is a waste of space. Don't use Unicode double-byte datatypes such as nchar, nvarchar and ntext unless you are doing multilingual applications.
{23E8ABDB-2A84-45B6-89B2-DE974601B35B}
Do you feel this rule needs an update?
