SQL Server/T-SQL Tutorial/Data Types/nVarChar

NVARCHAR(MAX)

   <source lang="sql">

2> IF OBJECT_ID("dbo.CustomerData") IS NOT NULL 3> DROP TABLE dbo.CustomerData; 4> GO 1> 2> CREATE TABLE dbo.CustomerData 3> ( 4> custid INT NOT NULL PRIMARY KEY, 5> txt_data VARCHAR(MAX) NULL, 6> ntxt_data NVARCHAR(MAX) NULL, 7> binary_data VARBINARY(MAX) NULL 8> ); 9> GO 1> 2> INSERT INTO dbo.CustomerData(custid, txt_data) 3> VALUES(102, "Customer 102 text data"); 4> GO 1> 2> drop table CustomerData; 3> GO</source>

nVarChar type column

   <source lang="sql">

5> CREATE TABLE MyTable (MyID Int IDENTITY(1,1) NOT NULL 6> , Description nVarChar(50) NOT NULL 7> , Region nVarChar(10) NOT NULL DEFAULT "PNW" 8> , CONSTRAINT PK_ID PRIMARY KEY (MyID)) 9> GO 1> 2> 3> drop table MyTable; 4> GO</source>