My Oracle Support Banner

E1: SEC: Sort Order for ASCII versus EBCDIC on the AS400 with Releases Xe and ERP 8 (Doc ID 633031.1)

Last updated on APRIL 04, 2025

Applies to:

JD Edwards EnterpriseOne Tools - Version S23 to SP24 [Release S23 to SP24]
IBM i on POWER Systems

Goal

What is the standard order of priority for EBCDIC databases on the AS400? Is it null, then blank, then lower case letters, then upper case letters, then numbers? For example, if I am adding inclusive row security to a table, and I want to allow everything up to a certain number, should I set it to allow null/blank through the specific number?

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.