Re: Order by of Special character in Oracle

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 2 Oct 2001 22:42:47 +0200
Message-ID: <trkad1i45vkq37@news.demon.nl>

"Xman74" <Xman74_at_jumpy.it> wrote in message news:5ad6eeaf.0110020135.7fb83e2a_at_posting.google.com...
> Hi everyone.
> I have a PROBLEM:
> I'm not try to put in "Order The Special character(~, Ç,º....etc)" in
Oracle
>
> How I can?
>
> PLEASE I'm IN A BIG PROBLEM
>
> Thanks All

Check out NLS_SORT in the SQL language reference and the NLS LANGUAGE manual.

The default is binary, as you already experienced.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Oct 02 2001 - 15:42:47 CDT