RE: Sorting characters with accents -- MIDRANGE-L

Assuming you're testing with interactive SQL:

F13 - Services
1 - Change session attributes
Page down to second screen
Set Sort sequence to *LANGIDUNQ
Set Language identifier to FRA
Enter
Enter
Select as, hex(az) from az order by az

If that doesn't do it we'll need to do further investigation.

Bruce Bruce Vining Services 507-206-4178

--- On Thu, 1/8/09, David FOXWELL <David.FOXWELL@xxxxxxxxx> wrote:

From: David FOXWELL <David.FOXWELL@xxxxxxxxx>
Subject: RE: Sorting characters with accents
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: Thursday, January 8, 2009, 8:41 AM

Bruce,

That order would be perfect.

But it's not changing anything for me. DSPSYSVAL QCCSID gives 65535.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]
De la part de Bruce Vining
Envoyé : jeudi 8 janvier 2009 15:28
À : Midrange Systems Technical Discussion
Objet : RE: Sorting characters with accents

Set your LANGID to FRA (to match I assume your CCSID of 297 given your
codepoints) and sort sequence to *LANGIDUNQ. This will approximate the order
you have in your list. I say approximate due to ê collating after é and è in
my quick test. You could create your own table to sort in your desired order
though (or find a more appropriate LANGID).

Bruce Bruce Vining Services 507-206-4178

--- On Thu, 1/8/09, David FOXWELL <David.FOXWELL@xxxxxxxxx> wrote:

From: David FOXWELL <David.FOXWELL@xxxxxxxxx>
Subject: RE: Sorting characters with accents
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxx>
Date: Thursday, January 8, 2009, 8:11 AM

Have I a chance in hell of getting this order : ?

a 81
à 7C
c 83
ç E0
e 85
ê 52
é C0
è D0

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]
De la part de Vern Hamberg
Envoyé : jeudi 8 janvier 2009 14:49
À : Midrange Systems Technical Discussion Objet : Re: Sorting characters with
accents

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To
post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment
to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To
post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment
to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To
post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment
to review the archives at http://archive.midrange.com/midrange-l.