Informix Error -495

Reasons / Common Causes

-495 is the LC_MONETARY counterpart of -492/-494: the same class of NLS-environment- configuration error, here for the locale category governing monetary formatting (currency symbols, decimal/thousands separators for MONEY values), rather than collation or character classification.

1. A typo or misspelling in the LANG/LC_MONETARY value.
2. A locale string not supported by the server's NLS configuration, even if valid in general OS terms.
3. LC_COLLATE/LC_CTYPE correctly configured but LC_MONETARY overlooked or mismatched — each locale category is configured independently.

Solutions / Resolution

1. Verify the exact value expected for the specific NLS-enabled database being connected to, consistent with the pattern for LC_COLLATE/LC_CTYPE.
2. Check for typos in the LANG/LC_MONETARY environment variable's current value.
3. Check all relevant locale categories together (LC_COLLATE, LC_CTYPE, LC_MONETARY, and any others in use) when configuring environment variables for an NLS-enabled database.

Examples

Checking current environment variable values

echo $LANG
echo $LC_MONETARY
-- compare against the exact value the target NLS-enabled
-- database actually requires for monetary formatting

Diagnostic Checks

1. Check the current values of LANG and LC_MONETARY.
2. Compare against the specific value the target database's NLS configuration requires.

Related Errors / Related Topics

• -492 — "LANG or LC_COLLATE environment variable invalid." The identical underlying issue, for LC_COLLATE instead of LC_MONETARY.
• -494 — "LANG or LC_CTYPE environment variable invalid." The identical underlying issue, for LC_CTYPE instead of LC_MONETARY.

Each NLS locale category (LC_COLLATE, LC_CTYPE, LC_MONETARY) is configured independently — check all of them together rather than assuming fixing one resolves the others.