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

Home -> Community -> Usenet -> c.d.o.server -> Order problem

Order problem

From: Gabor Konrad <gkonrad_at_freemail.hu>
Date: Thu, 3 Jul 2003 00:07:27 +0200
Message-ID: <bdvl3o$11ioso$1@ID-180124.news.dfncis.de>


A have never seen such a thing before:
A query result order is not proper when I use "order by" clause.

SQL> select * from mytable order by name; -nu
ra
40
70

Oracle give me an appropriate result only when I set the NLS_SORT parameter to BINARY with
"alter session set NLS_SORT='binary'"
command.
It is uncomfortable to call this command every time I start a session (logon).

I don't understand what is happening, cause no matter what is the value of NLS_SORT when the db instance is started (or system is started) (see below).

A should use Hungarian sort order, but I can't set binary sort order permanently neither.

What should I do to gain an ordered query result?

Thanks in advance

Here is my parameters:
select * from sys.nls_database_parameters;

NLS_LANGUAGE HUNGARIAN
NLS_TERRITORY HUNGARY
NLS_CURRENCY Ft
NLS_ISO_CURRENCY HUNGARY
NLS_NUMERIC_CHARACTERS .
NLS_CHARACTERSET EE8ISO8859P2
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT RR-MON-DD
NLS_DATE_LANGUAGE HUNGARIAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH24.MI.SSXFF
NLS_TIMESTAMP_FORMAT RR-MON-DD HH24.MI.SSXFF
NLS_TIME_TZ_FORMAT HH24.MI.SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT RR-MON-DD HH24.MI.SSXFF TZR
NLS_DUAL_CURRENCY Ft
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 9.2.0.1.0
Received on Wed Jul 02 2003 - 17:07:27 CDT

Original text of this message

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