About
NATIONAL CHAR is a SQL data type that:
- stores a char
- and uses as 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)
);