Home » Infrastructure » Other Operating Systems » EBCDIC sorting problem
EBCDIC sorting problem [message #99349] Fri, 16 July 2004 00:49
Johan Oeyen
Messages: 4
Registered: May 2003
Junior Member
Hi all,

Oracle 9.2.0.4
We're migrating our Unix DB to zOS1.4.
Current national character set = UTF8
NLS_COMP and NLS_SORT are the defaults at DB-level
We're using oracle forms 6i on a winNT application server
We're facing the following problem :
For varchar2 columns with numeric and alphanumeric characters
combined, the sorting in ebcdic is different than in ascii.
We can not change the business rules in the apps to accept this
new behaviour
We've been looking at 3 solutions :
1. Change the nls_sort=ascii7 and nls_comp=ansi on the client side
2. Change the nls_sort and nls_comp on the init file + the use of linguistic indexes
3. Change the columns to nvarchar.

What can you say about the pros and cons of every solution.

You can find more info about sorting linguistic data in
an Oracle Technical White paper

http://otn.oracle.com/tech/globalization/p...rting_10gR1.pdf

thx

Johan Oeyen
Previous Topic: Net send multiple computers
Next Topic: Wanted: an OS/390 Oracle DBA
Goto Forum:
  


Current Time: Thu Mar 28 04:47:05 CDT 2024