Re: Order methods

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Sat, 17 Feb 2001 01:33:42 GMT
Message-ID: <3A8DD4C0.EF890F90@pro-ns.net>

Renato De Ficis wrote:

> Hi,
> using this simply sql:
>
> SELECT A FROM B
> ORDER BY A
>
> are selected some record with this wrong order:
>
> A
> -------------------
> e
> r
> t
> 2
> 6
> 9
>
> This should be the correct order:
>
> 2
> 6
> 9
> e
> r
> t
>
> NOOO??!?!?
> Thanks for your precious help.
>
> --
> Posted from alpha.show.it [194.184.40.2]
> via Mailgate.ORG Server - http://www.Mailgate.ORG

I'd recommend you to read documentation first, before coming to any conclusion. The above sort order
is RIGHT for Oracle with US7ASCII or WE8ISO8859P1 charsets. The order will be different for
different charsets. Received on Fri Feb 16 2001 - 19:33:42 CST