16 December 2011

Varchar vs nvarchar in Sql Server


Varchar vs nvarchar in Sql Server

1. If your database will not be storing multilingual data you should use the varchar datatype instead. The reason for this is that nvarchar takes twice as much space as varchar.

multilingual means expressed in several languages

2.nvarchar support Unicode

  data types support Unicode data:

  nchar

  nvarchar

  ntext

Unitcode is a computing industry standard for the consistent encoding, representation and handling of text expressed in most of the world's writing systems.


No comments:

Post a Comment

Comments Welcome