NATIONAL CHAR

Overview

Fixed-length string of specific character set with limit up to 255 bytes.

See also: Data Types in 10.6 ES, in 10.5 ES, and in 10.4 ES

DETAILS

SYNONYMS

The following are synonyms for NATIONAL CHAR:

  • NATIONAL CHARACTER

  • NCHAR

EXAMPLES

CREATE TABLE national_char_example (
  example NATIONAL CHAR(32)
);
SHOW CREATE TABLE national_char_example\G
*************************** 1. row ***************************
       Table: national_char_example
Create Table: CREATE TABLE `national_char_example` (
  `example` char(32) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES