Oninit
Talk to an expert →

Informix Error -7203: DBNLS is not set or LC_COLLATE must be category-value.

Cause and resolution

DBNLS is not set or LC_COLLATE must be category-value.

You might receive this message when you try to access an external database that has a different locale than the current database. In order to use this NLS database, you must set the DBNLS environment variable to 1 or 2 and the LC_COLLATE environment variable to the specified category-value.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-7203 fires when accessing an external NLS database with a different locale than the current database, without the required environment variables set — per the official guidance.

  1. DBNLS not set to 1 or 2, per the official guidance — the first named requirement.
  2. LC_COLLATE not set to the specified category-value, per the official guidance — the second named requirement.
Solutions / Resolution
  1. Set the DBNLS environment variable to 1 or 2, per the official guidance.
  2. Set the LC_COLLATE environment variable to the specified category-value, per the official guidance.
Examples
Setting DBNLS and LC_COLLATE
$ export DBNLS=1
$ export LC_COLLATE=en_us.8859-1
Diagnostic Checks
  1. Check DBNLS and LC_COLLATE, and set them to the values required by the external NLS database's locale.
Related Errors / Related Topics
  • -7205 — "DBNLS is not set or LC_CTYPE must be set to category-value." The same underlying requirement, for LC_CTYPE rather than LC_COLLATE.

Accessing an external NLS database requires DBNLS and LC_COLLATE to be set to its locale's category-value.