Re: Sort problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 26 Mar 2002 23:24:39 +0100
Message-ID: <ua1tadsk9jqi5d@corp.supernews.com>

"R. Marx" <marx_at_ukl.uni-freiburg.de> wrote in message news:3CA03FF1.43697B5F_at_ukl.uni-freiburg.de...
> Hi all,
> when sorting a table by a field which contains strings like "abc-1" and
> "abc_1 the sorting doesn't work correctly, that is the strings are
> mixed. Seems as if Oracle doesn't distinguish between _ and -
> How can I get the db to sort the table correctly ?
> Oracle Server is 7.3.4, character set is WE8ISO8859P1.
> Thanks in advance...
>
> Regine
>

You did set the client's NLS_LANG environment variable/registry key correctly?

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Tue Mar 26 2002 - 16:24:39 CST