3. Understanding SQL Data Types : SQL Data Types : Character Data Types : Long Varchar Data Types
 
Long Varchar Data Types
The long varchar data type has the same characteristics as the varchar data type, but can accommodate strings up to 2 GB in length.
If a length is declared for this type of column, it represents the size of the inline space to store the initial n bytes of data for the large object. For more information, see Storing BLOBs Inline the Database Administrator Guide.
In embedded SQL, data handlers can be created, which are routines to read and write the data for columns that contain large objects. For more information on data handlers, see Data Handlers for Large Objects (see Data Handlers for Large Objects) and the Embedded SQL Companion Guide.