"Harald Maier" <maierh_at_myself.com> schrieb im Newsbeitrag
news:m3wud81g8l.fsf_at_ate.maierh...
> "Hans Sauren" <hsauren_at_gruen-ag.de> writes:
>
> > Hi all,
>
> > we use ORACLE 8.1.7. In the tables German characters like äöü have
> > to be stored. The parameters NLS_LANG is set to
> > GERMAN_GERMANY.WE8ISO8859P15, NLS_SORT to GERMAN and NLS_TERRITORY
> > to GERMANY. In selects without where-clause but order by n_name the
> > result is proper sorted like German where German ü is like u. But
> > when I force select n_name from adress where n_name >= 'Mü' all
> > other Mu are not in the resultset. Looking at the result set with
> > SQL*Plus 'Müller' is shown as 'MA¼ller' which might be US7ASCII.
> >
> > Has anybody an idea where I have to look for. Thanks for any
> > suggestion.
>
> I assume nls_comp points to binary. You should use ansi.
>
> ,----
> | nls_comp=ansi
> `----
>
> Harald
Hi Harald,
that was it. Thanks.
Hans Sauren
Received on Thu Aug 21 2003 - 01:30:31 CDT
