Home
Schema - Do you only use Unicode datatypes (nchar, nvarchar and ntext) in special circumstances?
  v2.0 Posted at 8/01/2020 2:30 PM by Christian Morford-Waite
Columns defined using the nchar and nvarchar 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.

​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 and nvarchar unless you are doing multilingual applications.

If you need to store more that 255 Characters, use Varchar(max) or nvarchar(max).

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments: