Re: HELP!!!! SORT ORDER

From: Serge Nantel <snantel_at_virtuo-cio.com>
Date: Mon, 04 Dec 2000 20:53:42 GMT
Message-ID: <qvTW5.29473$i%4.924422@news20.bellglobal.com>

Thank you

Yes I did and ORDER BY and I also I Check NLS_LANGUAGE.

Another option is to use NLS_SORT in your query they are the same?????

<denevge_at_my-deja.com> a écrit dans le message news: 90gut3$i3q$1_at_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:53:42 CST