English

Bug: Attribute tables containing Czech language characters do not sort properly

Description

In ArcCatalog, sorting columns that contain Czech characters, such as � and the digraph CH, are ignored when the data is stored in an ArcSDE geodatabase in Oracle. This occurs even if the NLS_SORT parameter is properly set in the database.

Cause

ArcSDE is not properly using the NLS_SORT database parameter.

Workaround

Set the NLS_SORT parameter in the dbinit.sde file.

  • When using an ArcSDE service connection, add the following environment variable to the dbinit.sde file on the ArcSDE server:

      set NLS_SORT=XCZECH

  • When making a direct connection to the geodatabase, create an etc directory under the client application installation directory, copy a dbinit.sde file to the etc directory, and add the NLS_SORT environment variable to it.

      set NLS_SORT=XCZECH

  • Another option, when using either an ArcSDE service connection or making a direct connection, is to create a system environment variable like the following:

    Variable name:  NLS_SORT
    Variable value: XCZECH