Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Order By Problem (maybe NLS_SORT)

Re: Oracle Order By Problem (maybe NLS_SORT)

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 26 Nov 1998 12:56:12 GMT
Message-ID: <73jj5c$dkm$1@news01.btx.dtag.de>


Hallo Jens,

probier einmal NLS_SORT = GERMAN_DIN. Dies ist die Telefonbuchsortierung.

Jens Trinkies schrieb:
>
> Hello,
> i have some trouble with the sort function of oracle.
> If i use ALTER SESSION SET NLS_SORT = GERMAN (or XGERMAN) the german
> characters work fine but the numeric characters come after the alpha
> characters.
> Example:
> SELECT * FROM TBL_TEST ORDER BY TXT_TEST
>
> TXT_TEST TXT_VALUE
> AA 1
> AB 2
> A1 3
> BA 1
> B2 10
>
> but i need:
> TXT_TEST TXT_VALUE
> A1 3
> AA 1
> AB 2
> B2 10
> BA 1
>
> when i use ALTER SESSION SET NLS_SORT = BINARY i will get what i want
> but the german letters ä,ö,ü and ß are not sorted the right way.
>
> If anyone knows how to sort numeric-chars before alpha-chars it would be
> nice to send an e-mail to
>
> jtr_at_sbk-ks.de
>
> Thanks in advance,
>
> Jens

--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Thu Nov 26 1998 - 06:56:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US