NIM043738 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM043738
Submitted	March 27, 2009
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	9.2
Operating System	Windows OS
Operating System Version	2003
Status	Will Not Be Addressed

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
```