SQL Data Type - NVARCHAR (NATIONAL CHARACTER VARYING)

Data System Architecture

About

NATIONAL VARCHAR is a SQL data type.

It stores a varchar and uses as character set:

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)
);





Discover More
Data System Architecture
SQL - Data Type

The Data Type of a column in SQL. They are defined in the ANSI/ISO SQL standard but may vary from sql engine (database) to another. The below table shows you the history of the data type in the ANSI...
Data System Architecture
SQL - National Character Set (String)

The National Character Set is a configuration that stores the character set value used by the national character data type: NCHAR (National Character) NVARCHAR (National Varying Character) By default,...
Data System Architecture
SQL - String Data Type

This page is the SQL data type that can be used in SQL to represent a string. The following data type are using the locale character set to encode the string: CHAR VARCHAR CLOB The following...



Share this page:
Follow us:
Task Runner