Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sort problem
Yes, NLS_LANG is set to GERMAN_GERMANY.WE8ISO8859P1. But I found out that
with changing NLS_SORT from GERMAN to BINARY the strings are correctly
sorted.
Thanks for your help,
regards
Regine
Sybrand Bakker schrieb:
> "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 Wed Mar 27 2002 - 02:23:00 CST