Last updated on AUGUST 02, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
On a new JAS instance when results on a grid are sorted ascending in a table, business view or databrowser, returns an incorrect sorting order, with numbers after alpha characters instead of the usual BINARY sort with numbers before alpha characters.
Another JAS instance ( on a different Windows server) performs the same queries to the same database using the same environment and returns the data in the expected sorting order (numbers before alpha characters)..
|BINARY SORT||WEST_EUROPEAN SORT|
Database: Oracle 22.214.171.124 on Oracle Linux 6.4
JAS Servers: Weblogic server 10.3.5 on Microsoft Windows x64 (64-bit) 2008 R2 and OAS 10g on Windows server 2003 x86
JDBC driver versions:
Note: Due to the use of different JVMs/JDKs, they have been configured to use different serialized tables.
WLS machine is a new install on a newer version of Windows, JDBC driver and JDK in comparison with OAS.
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