Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sorting column

sorting column

From: Bertrand <Bertrand_at_fersec.com>
Date: 24 Oct 2002 11:00:30 GMT
Message-ID: <20021024-12030-534490@foorum.com>

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/
Received on Thu Oct 24 2002 - 06:00:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US