Re: Numeric characters after alphabetic characters sorting varchar2 fields

From: Chuck <chuckh_at_softhome.net>
Date: 7 Jul 2003 13:02:43 GMT
Message-ID: <Xns93B15C028DCAEchuckhsofthomenet@130.133.1.4>

There's you're answer. Under Western European collating sequence, numbers come after alpha. Try this to prove it.

create table mytable (x varchar2(10));
insert into mytable values (0);
insert into mytable values ('a');
commit;

SELECT x FROM mytable ORDER BY NLSSORT(x,'NLS_SORT=BINARY'); X

---

0         
a         

2 rows selected    

SELECT x FROM mytable ORDER BY NLSSORT(x,'NLS_SORT=WEST_EUROPEAN'); X

---

a         
0         

2 rows selected    

drop table mytable;

--
Chuck

"Max" <massimo.panero_at_ideainformatica.org> wrote in news:be1ffo$6nib$1
@ID-121437.news.dfncis.de:



> NLS_LANGUAGE = ITALIAN

> NLS_SORT = WEST_EUROPEAN

> 

> "Chuck" <chuckh_at_softhome.net> ha scritto nel messaggio

> news:Xns93AD69D93C44Fchuckhsofthomenet_at_130.133.1.4...

>> What are your session's values for NLS_SORT and NLS_LANGUAGE?
>>
>> "Max" <massimo.panero_at_ideainformatica.org> wrote in news:be1drf$5fsm$1
>> @ID-121437.news.dfncis.de:
>>
>> > Hi!
>> > Why numeric characters are placed after alphabetic characters 
sorting
>> > varchar2 fields?
>> >
>> > Example:
>> > AAA
>> > BBB
>> > 111
>> > FFF
>> > XXX
>> > 666
>> > ZZZ
>> >
>> > Sorted:
>> > AAA
>> > BBB
>> > FFF
>> > XXX
>> > ZZZ
>> > 111
>> > 666
>> >
>> > I think is right:
>> > 111
>> > 666
>> > AAA
>> > BBB
>> > FFF
>> > XXX
>> > ZZZ
>> >
>> > Thank you!
>> >
>> >
>> >


> 

> 

Received on Mon Jul 07 2003 - 08:02:43 CDT