Search This Blog

Wednesday, July 18, 2012

nvarchar data type SQL Server

SQL Server > Data Types > nvarchar


  • variable length 
  • Unicode string data.
  • length can be a value from 1 through 4,000.
  • maximum storage size is 2 GB
Example


CREATE TABLE dbo.Person
(
   Name nvarchar(100)
);