Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Numeric characters after alphabetic characters sorting varchar2 fields
NLS_LANGUAGE = ITALIAN
NLS_SORT = WEST_EUROPEAN
"Chuck" <chuckh_at_softhome.net> ha scritto nel messaggio
news:Xns93AD69D93C44Fchuckhsofthomenet_at_130.133.1.4...
> What are your session's values for NLS_SORT and NLS_LANGUAGE?
>
> "Max" <massimo.panero_at_ideainformatica.org> wrote in news:be1drf$5fsm$1
> @ID-121437.news.dfncis.de:
>
> > Hi!
> > Why numeric characters are placed after alphabetic characters sorting
> > varchar2 fields?
> >
> > Example:
> > AAA
> > BBB
> > 111
> > FFF
> > XXX
> > 666
> > ZZZ
> >
> > Sorted:
> > AAA
> > BBB
> > FFF
> > XXX
> > ZZZ
> > 111
> > 666
> >
> > I think is right:
> > 111
> > 666
> > AAA
> > BBB
> > FFF
> > XXX
> > ZZZ
> >
> > Thank you!
> >
> >
> >
Received on Thu Jul 03 2003 - 09:44:25 CDT