Re: sorting column

Bertrand -

To expand on this just a bit, be sure to check out the official Oracle documentation dealing with the various national language features that Oracle employs. Specifically, look through the "Oracle8i National Language Support Guide, Release 2 (8.1.6)" (Oracle Part Number A76966-01) if you're dealing with the later versions of Oracle8i. For Oracle9i, there's a similar document.

A quickie search at http://tahiti.oracle.com and on the word "nls_sort" will give you many good places to start your hunt.

Thanks,
TG

Daniel Morgan wrote:

> Bertrand wrote:
>
> > Hello,
> >
> > when i do an orber by on a varchar2 column, the result is apparently sorted
> > using EBCDIC and not ASCII ('A' is before '0')
> > I have to add ascii(my_column) to get column sorted by ASCII.
> > Is it normal or my database is not correctly configured ?
> >
> > Thanks.
> >
> > --
> > Use our news server 'news.foorum.com' from anywhere.
> > More details at: http://nnrpinfo.go.foorum.com/
>
> Oracle has no default sort order. Sort order is dependent upon the NLS
> parameters and character set: The NLS parameters can be changed on the fly. So,
> for example, in Chinese, there are three different sort orders possible. You
> need to determine what your current parameters are and what they should be to
> give you the result set you wish.
>
> Daniel Morgan
Received on Thu Oct 24 2002 - 12:15:32 CDT