| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
