NCHAR

NCHAR is a synonym for the fixed-length CHAR string data type using the utf8 character set.

Overview

See NATIONAL VARCHAR.

EXAMPLES

CREATE TABLE nchar_example (
  example NCHAR(32)
);

SHOW CREATE TABLE nchar_example\G

*************************** 1. row ***************************
       Table: nchar_example
Create Table: CREATE TABLE `nchar_example` (
  `example` char(32) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}