ASA SQL Reference
  SQL Data Types
    Character data types

LONG VARCHAR data type [Character]

Function 

Arbitrary length character data.

Syntax 

LONG VARCHAR

Usage 

Arbitrary length strings. The maximum size is limited by the maximum size of the database file (currently 2 Gb).

In addition to the length of the string itself, there is some additional overhead for storage.

Standards and compatibility 

• SQL/92    Vendor extension.

• Sybase    Not supported in Adaptive Server Enterprise.

See also 

CHAR data type [Character]

CHARACTER VARYING (VARCHAR) data type [Character]