Insert lvarchar data

An application can insert data from a character host variable (char, string, fixchar, varchar, or lvarchar) into a database column of type LVARCHAR.

If the value is longer than the maximum size of the column the database server truncates the value if the database is non-ANSI. No warning is generated when this truncation occurs. If the database is ANSI and the value is longer than the maximum column size then the insert fails and this error is returned:

-1279: Value exceeds string column length.

If the host variable you use for the insert is a char or varchar, the database server casts the type to lvarchar.

When you write data to an LVARCHAR column, the database server imposes a limit of 32 KB on the column. If the host variable is a lvarchar data type and the data exceeds 32 KB, the database server returns an error. If the column has an input support function, it must use any data beyond 32 KB, if necessary, to prevent the database server from returning the error.