Informix Error -19829: LVARCHAR column size is too big.
Cause and resolution
LVARCHAR column size is too big.
This statement specifies a width for a LVARCHAR column that exceeds 32,739. Use the TEXT, BYTE or CLOB data type, which allow character strings of 2 gigabytes (TEXT or BYTE)or 4 terabytes (CLOB)for a column.
Otherwise, check the statement for typographical errors.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-19829 fires when an LVARCHAR column's specified width exceeds 32,739 — per the official
guidance.
- An
LVARCHARwidth over 32,739, per the official guidance — the direct, only cause.
Solutions / Resolution
- Use
TEXT,BYTE, orCLOBinstead, per the official guidance — these support character strings up to 2 gigabytes (TEXT/BYTE) or 4 terabytes (CLOB). - Otherwise, check the statement for a typographical error, per the official guidance.
Examples
An over-sized LVARCHAR column
CREATE TABLE tab (notes LVARCHAR(40000));
-- -19829: exceeds the 32,739 maximum
Corrected
CREATE TABLE tab (notes CLOB);
Diagnostic Checks
- Check the
LVARCHARwidth against the 32,739 maximum, and switch toTEXT/BYTE/CLOBif genuinely larger content is needed.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -19829 in this set yet.
An LVARCHAR column's width exceeds 32,739 — use TEXT/BYTE/CLOB for larger content.