# E021-02: CHARACTER VARYING data type (including all its spellings)

statement ok
CREATE TABLE TABLE_E021_02_01_01 ( ID INT PRIMARY KEY, A CHAR VARYING ( 8 ) )

statement ok
CREATE TABLE TABLE_E021_02_01_02 ( ID INT PRIMARY KEY, A CHAR VARYING ( 8 CHARACTERS ) )

statement ok
CREATE TABLE TABLE_E021_02_01_03 ( ID INT PRIMARY KEY, A CHAR VARYING ( 8 OCTETS ) )

statement ok
CREATE TABLE TABLE_E021_02_01_04 ( ID INT PRIMARY KEY, A CHAR VARYING )

statement ok
CREATE TABLE TABLE_E021_02_01_05 ( ID INT PRIMARY KEY, A CHARACTER VARYING ( 8 ) )

statement ok
CREATE TABLE TABLE_E021_02_01_06 ( ID INT PRIMARY KEY, A CHARACTER VARYING ( 8 CHARACTERS ) )

statement ok
CREATE TABLE TABLE_E021_02_01_07 ( ID INT PRIMARY KEY, A CHARACTER VARYING ( 8 OCTETS ) )

statement ok
CREATE TABLE TABLE_E021_02_01_08 ( ID INT PRIMARY KEY, A CHARACTER VARYING )

statement ok
CREATE TABLE TABLE_E021_02_01_09 ( ID INT PRIMARY KEY, A VARCHAR ( 8 ) )

statement ok
CREATE TABLE TABLE_E021_02_01_10 ( ID INT PRIMARY KEY, A VARCHAR ( 8 CHARACTERS ) )

statement ok
CREATE TABLE TABLE_E021_02_01_11 ( ID INT PRIMARY KEY, A VARCHAR ( 8 OCTETS ) )

statement ok
CREATE TABLE TABLE_E021_02_01_12 ( ID INT PRIMARY KEY, A VARCHAR )
