sorting: parentheses

From: Tom Odul <tom_odul_at_hotmail.com>
Date: Mon, 25 Mar 2002 11:19:45 GMT
Message-ID: <lJDn8.87248$5d.1538970692@hestia.telenet-ops.be>

My Oracle: Oracle 8i Enterprise Edition, Release 2, Version 8.1.6 for Windows NT/2000

I have a problem sorting records which start with parentheses.

I want to sort them like this:

rex
sedes
(sedes

timor

It works on my Windows2000/Oracle server, but when I export/import the db to a NT4/Oracle server, it sorts like this:

(sedes

rex
sedes
timor

At http://www.stylusinc.net/technology/Oracle9i/sorting.shtml, I read that you can modify the sorting capabilities of Oracle 9. Does anyone know if it's possible in Oracle 8, how to do it, and if it will fix my problem?

Thanx in advance

Tom Received on Mon Mar 25 2002 - 05:19:45 CST