Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> sorting column
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
![]() |
![]() |