SQL VARCHAR Vs NVARCHAR Datatype

In SQL Server, the data types VARCHAR and NVARCHAR exist.

The primary distinction between varchar and narchar is that NVARCHAR is used to store Unicode characters, whereas VARCHAR is used to store non-Unicode characters.

In varchar, data is stored in 1 byte per character, whereas in nvarchar, it is stored in 2 bytes per character.

Varchar supports up to 8000 characters in field definition, while nvarchar supports up to 4000 characters.

SQL VARCHAR Datatype

VARCHAR is an AQL Server data type that refers to variable characters.

VARCHAR is used to store non-Unicode characters.

In VARCHAR, memory is allocated based on the characters inserted.

Example: A table with 2 VARCHAR columns.

CREATE TABLE Varyingchar
( 
  Id INT IDENTITY, 
  FullName VARCHAR(100),
  Address VARCHAR(250)
);
GO  

INSERT INTO Varyingchar VALUES (1,'Smithi', '4939 Conifer Drive, Seattle');  
INSERT INTO Varyingchar VALUES (2,'Jacquiline', '456 Olen Thomas Drive , Texas');  
INSERT INTO Varyingchar VALUES (3'Jersy', '366 Archwood Avenue, Cheyenne');


SELECT * FROM DemoTable;

Output: The output of above query is

SQL NVARCHAR Datatype

NVARCHAR is a SQL Server data type that refers to variable characters.

NVARCHAR is used to store Unicode characters.

In a data base, several languages can be kept. If other languages are utilised, NVARCHAR will require double the amount of space to store an extended set of characters.

Example: A table with 2 NVARCHAR columns.

CREATE TABLE Person
( 
  Id INT IDENTITY, 
  FullName NVARCHAR(100),
  Address NVARCHAR(250)
);                        
GO  

INSERT INTO Person VALUES (1,'Harold ', '4893 Archwood avenue,Seattle, Washington');  
INSERT INTO Person VALUES (2,'Wilson', '4450 Payne Street, Spring Lake, London'); 
INSERT INTO Person VALUES ('3,'Taylor', NULL); 
GO  

SELECT * FROM DemoTable;

Output: The output of nvarchar datatype is

SQL Differnce Between VARCHAR AND NVARCHAR DATA TYPE

The main differences between varchar & nvarchar points are tabulated:-