Re: sorting: parentheses
Date: Mon, 25 Mar 2002 16:27:42 GMT
Message-ID: <3C9F5008.B10FCDFF_at_exesolutions.com>
Likely you have database instances created with different character sets.
Daniel Morgan
Tom Odul wrote:
> 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 - 17:27:42 CET