Re: sort/select discrepancy with umlaut Oracle 7

Thanks Lothar,

I'll give it a try.

Thomas

Lothar Armbrüster <la_at_oktagramm.de> schrieb in im Newsbeitrag: PM00038744372319BE_at_hades.unknown.dom...
> Thomas Noone wrote:
> >

 [...]
> >
> > Using "select company from adresses where company >= 'K' order by
> > company",
> > lists companies starting with umlaut A (ae) followed by companies
> > starting
> > with K or larger.
> >
> > How can I get Oracle to select as it sorts? That is, if Ae is sorted
> > before
> > K, do the same with select and NOT select Ae?
> >
> Hello Thomas,
> try this:
>
> select company from adresses where nlssort(company)>=nlssort('K');
>
> You might consider creating a function based index on nlssort(company)
> if this kind of query occurs more often...
>
> Hope that helps,
> Lothar
>
> --
> Lothar Armbrüster | la_at_oktagramm.de
> Hauptstr. 26 | la_at_heptagramm.de
> D-65346 Eltville | lothar.armbruester_at_t-online.de
Received on Sat Jun 23 2001 - 08:04:34 CDT