RSS Feed   Twitter

Difference in “varchar” and “nvarchar” in SQL Server

Posted on July 15th, 2010
Get articles everyday as a email directly to your inbox:
Click to publicize, if you like this article :

This article explains the difference between varchar and nvarchar datatype in SQL Server.

nVarchar Varchar
varchar stores UNICODE data.  Means it store UNICODE or multilingual data. Varchar Stores ASCII data
UNICODE requires 2 bytes for each character you store. This Means single row of a single nvarchar column can only be nvarchar (4000) Because because of the row size limitations of Sql Server is the same as the page size limit, which is 8060 bytes ASCII only requires 1 byte for each character.
This means a single row of a single varchar column can be varchar(8000) because of the row size limitations of Sql Server is the same as the page size limit, which is 8060 bytes

Possibly Related posts:

  1. SQL Server Pivot Table Example
  2. Execute dynamic Query in SQL Server
  3. Use of OPENXML in SQL Server
  4. Between Clause problem in Date comparison – SQL Server
  5. Get the FortNight Start and End date – SQL Server
Posted in SQL Server Tags:
«
»
You can leave a response, or trackback from your own site.