Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Order problem
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.0Received on Wed Jul 02 2003 - 17:07:27 CDT
![]() |
![]() |