This topic describes how to create data of the VARCHAR2 type in PolarDB-O.

Prerequisites

The VARCHAR2 data type is enabled by running the following statements. By default, PolarDB-O does not support the VARCHAR2 data type.

alter system set polar_enable_varchar2_length_with_byte=on;
select pg_reload_conf();
show polar_enable_varchar2_length_with_byte;

Syntax

 VARCHAR2(maximum_size [CHAR | BYTE])

Parameters

Parameter Description
maximum_size The maximum length of the VARCHAR2 data type.
[CHAR | BYTE] The method that is used to measure the VARCHAR2 data length. Valid values: CHAR and BYTE.

Examples

create table t (col varchar2(10 byte));
create table t (col varchar2(10 char));