Oninit
Talk to an expert →

Informix Error -9648: Invalid value specified for a Boolean type

Cause and resolution

Invalid value specified for a Boolean type

't','T' or 'f','F' or NULL are the only valid values for boolean type.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9648 fires when a value other than 't', 'T', 'f', 'F', or NULL is supplied for a BOOLEAN column/variable — per the official guidance.

  1. A value other than 't'/'T'/'f'/'F'/NULL supplied for a BOOLEAN, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Use only 't', 'T', 'f', 'F', or NULL for a BOOLEAN value, per the official guidance.
Examples
An invalid Boolean literal
INSERT INTO tab (bool_col) VALUES ('yes');   -- -9648
Corrected
INSERT INTO tab (bool_col) VALUES ('t');
Diagnostic Checks
  1. Check the value supplied for the BOOLEAN column/variable, and correct it to 't'/'T'/'f'/'F'/NULL.
Related Errors / Related Topics
  • -9646 — "Result of a Boolean expression is not of Boolean type." A related Boolean- type error, on a conditional expression's overall result type rather than an invalid literal.

A value other than 't'/'T'/'f'/'F'/NULL was given for a BOOLEAN — correct it.