Oninit
Talk to an expert →

Informix Error -23197

-23197 Database locale information mismatch.

The locale information GL_CTYPE or GL_COLLATE in the system catalog of the specified database does not match the locale information in the specified environment variable DB_LOCALE. Check the value of DB_LOCALE.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-23197 fires when the GL_CTYPE or GL_COLLATE locale information stored in the database's system catalog doesn't match the DB_LOCALE environment variable — per the official guidance.

  1. GL_CTYPE/GL_COLLATE in the system catalog disagreeing with DB_LOCALE, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Check the value of DB_LOCALE, per the official guidance.
Examples
Checking DB_LOCALE
$ echo $DB_LOCALE
Diagnostic Checks
  1. Compare DB_LOCALE's value against the catalog's stored GL_CTYPE/ GL_COLLATE, and correct the mismatch.
Related Errors / Related Topics
  • -23196 — "Unknown locale in selected database." A related database-locale error, general to the whole locale not matching rather than a specific GL_CTYPE/ GL_COLLATE mismatch.
  • -23198 — "GL-COLLATE information is missing from the system catalogs." A related catalog-locale error, on GL_COLLATE being entirely absent rather than mismatched.
  • -23199 — "GL_CTYPE information is missing from the system catalogs." A related catalog-locale error, on GL_CTYPE being entirely absent rather than mismatched.

The catalog's stored GL_CTYPE/GL_COLLATE didn't match DB_LOCALE — check DB_LOCALE.