Re: SQL - Strange behavior

From: Stephen <stephen_broscoe_at_email.msn.com>
Date: 2000/06/15
Message-ID: <#p9gqTv1$GA.138@cpmsnbbsa08>#1/1

Hi Christian:

I would expect your query to return no rows, but I wouldn't expect 'ZUABSCHLAG' to sort
before the other records. How are your NLS_LANGUAGE and/or NLS_SORT initialization
parameters set? NLS_LANGUAGE specifies the default sorting sequence for character
data when ORDER BY is specified.

Schoene Gruesse,

Stephen

---

Broscoe Consulting
Stephen Broscoe, President
E-mail: stephen_broscoe_at_msn.com

---

Christian Hartmann <c.hartmann_at_tmp-office.de> wrote in message news:8iaodg$4h4ne$1_at_fu-berlin.de...
> Hi there,
>
> I have very strange results with a table in which are "normal" Strings and
> Strings like 0001 included.
>
> Well, I did the following:
>
> Create table test (test_nr char(18))
>
> Values:
>
> Insert into test values ('ZUABSCHLAG')
> Insert into test values ('0001')
> Insert into test values ('0002')
>
> 1. Query
>
> Select test_nr from test order by test_nr
>
> Result:
> ZUABSCHLAG
> 0001
> 0002
>
> 2. Query
>
> Select test_nr from test where test_nr>'ZUABSCHLAG'
>
> Result:
> No rows
>
> Thanx for any help,
>
> Christian Hartmann
>
>
>
>
Received on Thu Jun 15 2000 - 00:00:00 CDT