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:




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