2 replies to this topic

[Bob C]

I just came across a difference in sort order between a Group in the sidebar and a sorted custom report. In the Group sidebar they were sorted by last name, given with individuals with no middle given name appearing before those with a middle given name.

 

In a custom report based upon the group and sorted by surname and then given name, the individuals with middle given names  sorted before those without.

 

Either there are two sort functions being used or a collation sequence is different between the two sorts.

 

https://postimg.cc/gallery/2tnmls6qk/

 

[TomH]

Two different sort systems and, possibly, two different collation sequences. I suspect the group in the sidebar is a SQLite sort using the RMNOCASE collation while the custom report might be a Delphi sort with an unknown collation.

[Renee Zamora]

Confirming this difference is noted in the development list.