Re: Oracle 8.1.7 sort order

I did manage to get rows as I wanted them with alter session set nls_sort = binary and
using nls_sort -function in my queries. Now they both return same data. (with 2nd clause I get same rows before 'N50295X350' as I get with 1st clause)

Thank you for your reply...

"Enkidu" <rcrowley-enkidu_at_learningframework.com> wrote in message news:2cQ39.14$eb.13859_at_news2.west.cox.net...
> It looks like you might have the wrong character set, at least for what
> you're used to seeing in your native language. Your collating sequence is
> what orders the special characters and numbers prior to letters. What
> character set (NLS setting) does your database have?
>
> -Roger Crowley
>
> "Jukka Peltonen" <jukka.peltonen_at_helsoft.fi> wrote in message
> news:1028632504.672626_at_ns2...
> > Hello, I hope someone can explain this to me ....
> >
> > Enviroment: Oracle 8.1.7, W2K, client 8.1.6 (oci.dll version)
> >
> > Table: NIMIKE
> > Column:NIMIKEKOODI VARCHAR2 (40) NOT NULL
> >
> > I get different results from following two SQL-clauses
> >
> > 1st clause:
> > select nimikekoodi from nimike where nimikekoodi < 'N50295X350'
> >
> > Result: Rows that starts with numbers and "normal strings" that are
> smaller
> > than 'N50295X350'
> >
> > Data:
> > (EI)PAL495X703
> > // KALV 80
> > // VSK-MPE
> > 001271X495
> > ....
> > N50295X278
> >
> > I think this is correct result.
> >
> > 2nd clause:
> > select nimikekoodi from nimike order by nimikekoodi
> >
> > Result: All rows, but order is funny (at least I think so) because now
> those
> > rows that starts with numbers are now after
> > row 'N50295X350'
> >
> > Data:
> > '// KALV 80'
> > ....
> > 'N50295X350'
> > ....
> > 9,964VKI
> >
> > I think this is NOT a correct result.
> >
> > What am I doing wrong?
> >
> > I think that there is something wrong because field nimikekoodi values
are
> > handled differently
> > depending on if it is in where- or order part of SQL-clause
> >
> >
>
>
Received on Wed Aug 07 2002 - 03:01:46 CDT