SQL Data Type - NVARCHAR (NATIONAL CHARACTER VARYING)

About

NATIONAL VARCHAR is a SQL data type.

It stores a varchar and uses as character set:

• the National Character set
• instead of the character set of the operating system

Example

A create table statement that creates:

• a table named NVARCHAR
• with a column named NVARCHAR that has:
  • a NVARCHAR data type
  • and a maximum length of 300.

-- Thanks to the double quote, we can use the name of the data type as name for the table and the column 
create table "NVARCHAR" (
  "NVARCHAR" NVARCHAR(300)
);