Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
ESQL/C GuideThe Informix® ESQL/C Programmer's Manual explains how to use Informix® ESQL/C, the Informix® implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
What is Informix® ESQL/C?
Character and string data typesThese topics explain how to use character data types in the Informix® ESQL/C program.
Fetch and insert character data types
Fetch and insert lvarchar dataWhen an application uses a lvarchar host variable to fetch or insert a data value, Informix® ESQL/C must ensure that the value fits into the host variable or database column.
Insert lvarchar data

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.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.