Re: HELP!!!! SORT ORDER

From: <denevge_at_my-deja.com>
Date: Mon, 04 Dec 2000 20:30:27 GMT
Message-ID: <90gut3$i3q$1@nnrp1.deja.com>

Yes, such things can be very confusing.
The problem is that the NLS settings on the 2 environments are not the same.
Check NLS_LANGUAGE.

Another option is to use NLS_SORT in your query.

Hope this helps
Gert

In article <KKRW5.28426$i%4.914102_at_news20.bellglobal.com>, "Serge Nantel" <snantel_at_virtuo-cio.com> wrote:
> I have 2 Oracle database one running on UNIX and one running on NT4
>
> I run a select and the result is not the same
>
> On UNIX On NT4
> Select bla bla bla Select bla bla bla
> ABTYP AB3050
> AB3050 ABTYP
>
> On UNIX the sort is not in the same order as the one on NT4 ???
>
> thank you kindly
> Serge
> snantel_at_virtuo-cio.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 04 2000 - 14:30:27 CST