Re: Sorting characters with accents

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Here's what I see -

The first sort is done according to the actual hex value of the 
character in AZ - notice that it is in order by the hex numeric value - 
numbers come before letters - the order is 0123456789ABCDEF.

Now the second sort is done according to the character representation of 
the hex value - so letters come before numbers, in the normal EBCDIC 
order. Letters before numbers.

In embedded SQL you can set the sort sequence - set option srtseq=*JOB 
or *HEX or *JOB or *JOBRUN or *LANGIDSHR or *LANGIDUNQ - you can even 
name a sort table. This is an option you set at the top of the source 
code and applies to everything in a single code unit - so if you need 
both case-sensitive and case-insensitive options, you have to do it with 
2 modules - a great case for ILE!!

Eh?
Vern

David FOXWELL wrote:
> Hi,
>
> With this request : SELECT AZ , hex( AZ ) FROM az ORDER BY     AZ
>
> I'm getting
> AZ  HEX ( AZ )
> ê       52
> à       7C
> a       81
> c       83
> e       85
> é       C0
> è       D0
> ç       E0
>
> If I use ORDER BY hex(AZ)
> I get
> AZ  HEX ( AZ )
> é       C0
> è       D0
> ç       E0
> ê       52
> à       7C
> a       81
> c       83
> e       85
>
> Can anyone tell me how the sorting works?
> Thanks
>