Example: VARCHAR Data Type
The following statement creates a table that defines two VARCHAR columns: InfoKey and InfoData.
CREATE TABLE InfoTable (InfoKey VARCHAR(10) NOT NULL ,InfoData VARCHAR(16384) ) UNIQUE PRIMARY INDEX ( InfoKey );
The following statements insert character data of varying lengths into the InfoKey and InfoData columns:
INSERT INTO InfoTable ('001_5_799', 'Data for key 001_5_799');
INSERT INTO InfoTable ('2', 'Data for key 2');
Example: LONG VARCHAR Data Type
The following statement creates a table that defines a LONG VARCHAR column called InfoData.
CREATE TABLE InfoTable (InfoData LONG VARCHAR);