Siebel Remote - Null Values Sort Behaviour in Local SQL Anywhere Database vs Server (Doc ID 502056.1)

Last updated on APRIL 13, 2017

Applies to:

Siebel Remote - Version 7.7.2.2 [18356] to 15.18 [IP2015] [Release V7 to V15]
All Platforms
Version: 7.7.2.2 [18356]

Database: Oracle 9.2.0.4

Application Server OS: Microsoft Windows 2003 Server SP1

Database Server OS: IBM AIX 5L 5.2



This document was previously published as Siebel SR 38-1945817781.

Symptoms

Hi,
We are using an Oracle 9.2.0.4 database in AL32UTF8 and binary sort.

We have noticed that the sort order in not the same for local and oracle db especially when a record is empty.

The result of the following query on local db select * from sys.sysoption where "option" = 'Sort_Collation' is internal.

The result of the following query on Oracle SELECT * FROM NLS_DATABASE_PARAMETERS is PARAMETER    VALUE
NLS_LANGUAGE    AMERICAN
NLS_TERRITORY    AMERICA
NLS_CURRENCY    $
NLS_ISO_CURRENCY    AMERICA
NLS_NUMERIC_CHARACTERS    .,
NLS_CHARACTERSET    AL32UTF8
NLS_CALENDAR    GREGORIAN
NLS_DATE_FORMAT    DD-MON-RR
NLS_DATE_LANGUAGE    AMERICAN
NLS_SORT    BINARY
NLS_TIME_FORMAT    HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT    DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT    HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT    DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY    $
NLS_COMP    BINARY
NLS_LENGTH_SEMANTICS    BYTE
NLS_NCHAR_CONV_EXCP    FALSE
NLS_NCHAR_CHARACTERSET    UTF8
NLS_RDBMS_VERSION    9.2.0.4.0

How could we solve that issue?
Thanks

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms