NATIONAL VARCHAR

Overview

In 23.09:

Variable-length string of specific character set with limit up to 65,535 bytes.

In 6.1, 6.0, 5.3:

Not present

See also: Data Types for MariaDB Xpand 23.09, in 6.1, in 6.0, and in 5.3

USAGE

NATIONAL VARCHAR[(<number_of_bytes_per_value>)]

DETAILS

Data Type

Minimum Number of Bytes

Maximum Number of Bytes

NATIONAL VARCHAR

0 (if omitted, the default is 65535)

65535

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

While Xpand accepts the NATIONAL VARCHAR data type on table create, it is silently replaced with VARCHAR:

CREATE TABLE national_varchar_example (
   example NATIONAL VARCHAR(32)
);

SHOW CREATE TABLE national_varchar_example\G

*************************** 1. row ***************************
       Table: national_varchar_example
Create Table: CREATE TABLE `national_varchar_example` (
  `example` varchar(32) CHARACTER SET utf8 DEFAULT NULL
) CHARACTER SET utf8 /*$ SLICES=3 */

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.09

  • Added in MariaDB Xpand 23.09.1.

6.1

  • Not present.

6.0

  • Not present.

5.3

  • Not present.

EXTERNAL REFERENCES