Re: order by question

Hi TurkBear,

that its. When i set NLS_SORT to BINARY, then its okay.

Thanks

Frank

TurkBear <johng_at_mm.com> schrieb in im Newsbeitrag: 38553903.2053683_at_super.news-ituk.to...
> It may depend on the nls_ parameters
> because when I created the same table and data I got the result you
wanted...
>
> I'm running Oracle 8.15, with NLS_LANG = AMERICAN and NLS_SORT = BINARY
>
> Maybe Thomas K is listening....
>
>
>
> "Frank Streitzig" <Frank.Streitzig_at_T-Online.de> wrote:
>
> >Hi,
> >
> >i have a order by question. I have a table x with one column t char(5).
The
> >table contain 6 rows.
> >
> >#1
> >1)
> >#2
> >2)
> >#3
> >3)
> >
> >I like sort table (select t from x order by t), but receive no order.
> >I like follow sorting:
> >
> >#1
> >#2
> >#3
> >1)
> >2)
> >3)
> >
> >Can anybody help me?
> >
> >Sorry for my language. :-)
> >
> >Frank Streitzig
> >Germany
> >
>
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers
==----- Received on Tue Dec 14 1999 - 01:45:39 CST