The long varchar data type has the same characteristics as the varchar data type, but can accommodate strings up to two GB in length. Do not declare a length for long varchar columns. In embedded SQL data handlers can be created, which are routines to read and write the data for long varchar (and long byte) columns. For details about data handlers, see Data Handlers for Large Objects in the “Embedded SQL” chapter, and the Embedded SQL Companion Guide.