ORDER BY sorts is different

[GT]

In confluence I want 2 tables next to each other:

One which shows me some filtered Epics ORDER BY "Epic Name" ASC and the other which shows me filtered Report Item which have an epic link to these Epics from first table and ORDER BY "Epic Link" ASC.

My expectation is to have the same order like

Table1                                                           Table 2

Key | Epic Name                                            Epic Link | Status

---------------------------------------- ---------------------------

M7    Anton                                                 Anton       Closed

M9    Ärtem                                                 Ärtem       Closed

M2    Ason                                                   Ason         Closed

M3    Berta                                                   Berta         Open  

M4    Berta:                                                  Berta:         Open

M1    Carlo                                                   Carlo         Closed

But when there are special character in the epic name like ":" or German "Ä" etc. this is really different:

Table1                                                           Table 2

Key | Epic Name                                            Epic Link | Status

---------------------------------------- ---------------------------

M7    Anton                                                 Anton       Closed

M2    Ason                                                   Ärtem       Closed

M3    Berta                                                   Ason         Closed

M4    Berta:                                                  Berta:        Open  

M1    Carlo                                                   Berta         Open

M9    Ärtem                                                 Carlo         Closed

Only thing is the EPICs are in another JIRA project then the Reports. I checked it in JIRA as well with the same (wrong) result.

Any idea what happend here?

br

[Dick]

Hi @GT Welcome to the Atlassian Community

What you are experiencing with these special diacritics is that the corresponding utf-16 code of those characters is way higher than the code for Z. 

Hence the mixed-up alphabetical order you are experiencing.

Kind regards,

Dick

[Bill Sheboy]

Hi @GT -- Welcome to the Atlassian Community!

Adding to the answer from @Dick there is an old defect noting this difference in behavior between the field searches in JQL documented as case-insensitive and the ORDER BY undocumented as using the full character code: https://jira.atlassian.com/browse/JRASERVER-69833

Kind regards,
Bill

[GT]

Hey, thanks for the replies. Looks like then I will have to live with it for now.

br,

GT

[Dick]

Thanks @Bill Sheboy for the addition of the documentation. 
You really put the cherry on top :)

Dick