Re: Sort order question.

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Fri, 01 Dec 2000 22:31:24 GMT
Message-ID: <9098rs$cr$1_at_nnrp1.deja.com>

In article <907jta$9jh$1_at_news.ipartners.pl>, "Borutto" <marcin.borucki_at_nospama.a.nc-virtual.com> wrote:
> Helo .
>
> I have a problem. although i was looking in the doc i couldn't find it.
>
> Please if any one knows tell me what is a sort mechanizm on the function
> max() when it is performed on the collumn of the varchar2 type.
> The max is chosen basing on what condisions ASCII numeration or ....
>
> Please let me know.
>
> Regards.
>
> Martinek Borut Borucki
>
>

The sort order of character datatypes is defined by national language sort order. In short, order of letters should be the same as in national alphabet, other characters are sorted as Oracle decided. For details, look up in Oracle NLS documentation, it's available on OTN.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 01 2000 - 23:31:24 CET

This message: [ Message body ]
Next message: Aleksandr Kononov: "Re: what do you use to print oracle shemas"
In reply to Borutto: "Sort order question."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message