Home » SQL SERVER NVARCHAR

SQL SERVER NVARCHAR

SQL Server NVARCHAR is used to store uniqcode string data of variable length, it can store both unicode and non unicode strings.




  • NVARCHAR data type is used to store Unicode string data of variable length, Can store both unicode and non-unicoden strings.
  • It stores data at 2 byte per character.
  • It supports up to 4000 characters.

Syntax

nvarchar(n)

or

nvarchar(max)

n specify the string length that ranges from 1 to 8000. Default value fo n is 1.

max specify the maximum storage size which is 231-1 bytes (2 GB)

Lets Look at an example to demonistarte the properties of NVARCHAR

Data Storage Vs Length

Here we have a nvariable @strtxt of datatype varchar of size 30.

As varchar takes 2 bytes per character to store the data so it takes 9 bytes to store @strtxt value ‘microsoft’ that is lenght of @strtxt * 2 bytes (9 *2) =18.

It is variable -length so, it takes actual length size of string that is 9 for ‘‘microsoft’.

DECLARE @Str NVARCHAR(30)
SET @Str = 'Microsoft'
SELECT @Str AS Strtext, DATALENGTH(@Str) AS StrText_OccupiedLength ,
LEN(@Str) AS StrText_length

 

Using NVARCHAR to store unicode Data

NVarchar can store unicode data , again we try to store hindi language text to @str variable of type nvarchar.

Note: Always make sure that you prefix Unicode string literals with an N prefix.

DECLARE @Str NVARCHAR(30)
SET @Str = N'माइक्रोसॉफ्ट'
SELECT @Str AS Strtext, DATALENGTH(@Str) AS StrText_OccupiedLength ,
LEN(@Str) AS StrText_length

 

Recomended for you

How to get the detailed information of all datatypes in SQL Server ?

SQL Server VARCHAR vs NVARCAR

SQL Server CHAR vs NCHAR




Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.