About

NATIONAL CHAR is a SQL data type that:

• stores a char
• and uses as character set:
  • the National Character set
  • instead of the default character set of the operating system

Example

A create table statement that creates:

• a table named NCHAR
• with a column named NCHAR that has:
  • a NCHAR 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 "NCHAR" (
  "NCHAR" NCHAR(300)
);