Re: problems with sorting german words

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/05
Message-ID: <960233083.7633.1.pluto.d4ee154e@news.demon.nl>#1/1

try alter session set nls_sort = 'German'

Hth,

Sybrand Bakker, Oracle DBA

Sascha Kiefer <skiefer_at_pikon.com> schreef in berichtnieuws 393bd666.33941815_at_news.netfab.de...
> Hi,
>
> I want to read words from an table and want to sort them correct. But
> I've got some problems with using order by:
>
> this are the words in the table: Ba aa äq Üe Cb cc
>
> this is waht I expect: aa äq Ba Cb cc Üe
>
> this is what I get: Ba Cb aa cc äq Üe
>
> Is there a parameter I cant set ?
>
> Thanks
> Sascha
> ----------------------------------------------------------
> Sascha Kiefer
> PIKON International Consulting Group GmbH
> http: www.pikon.com E-Mail: skiefer_at_pikon.com
> Tel: +49-681-37962-0 Fax: +49-681-37962-90
> ----------------------------------------------------------
Received on Mon Jun 05 2000 - 00:00:00 CDT