Informix Error -9819: Column (column_name) incorrect type for storage in sbspace.

Cause and resolution

Column (column_name) incorrect type for storage in sbspace.

You have attempted to store a column in an sbspace that is not an appropriate type. Only CLOB and BLOB columns can be stored in sbspaces. Columns of types TEXT and BYTE may not be stored in an sbspace.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9819 fires when a column of an unsupported type is stored in an sbspace — per the official guidance; only CLOB and BLOB columns can be stored in sbspaces, not TEXT or BYTE.

A TEXT or BYTE column directed to an sbspace, per the official guidance — the direct, only cause.

Solutions / Resolution

Use CLOB or BLOB for columns stored in an sbspace, per the official guidance, rather than TEXT or BYTE.

Examples

A TEXT column directed to an sbspace

CREATE TABLE tab (notes TEXT IN my_sbspace);   -- -9819

Corrected

CREATE TABLE tab (notes CLOB IN my_sbspace);

Diagnostic Checks

Check the named column's data type, and change it to CLOB/BLOB if it's TEXT/BYTE and needs sbspace storage.

Related Errors / Related Topics

-9814 — "Invalid default sbspace name (sbspace_name))." A related sbspace error, on the sbspace's existence rather than the column's type compatibility.

A TEXT/BYTE column was directed to sbspace storage, which only supports CLOB/BLOB — change the column type.