SQL Data Type - NCHAR (NATIONAL CHARACTER)

Data System Architecture

About

NATIONAL CHAR is a SQL data type that:

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





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