Attribute table sorting issues in text fields

Question

Attribute table sorting issues in text fields. ArcPro 2.4.1

The clip below shows a common attribute in two separate feature classes.  The field structure and type are identical, there are no extraneous spaces.  Both tables contain identical data in this field and are sorted in ascending order.  The sort order of the dash "-" character is different.  any ideas?

DanPatterson_Retired · Answer

BUG-000095569: Text fields are not sorted correctly in the Show Sel..

It is almost Friday, so I will look no more.

See if the Sort tool does the right thing, and move on from temporary sorting if that isn't the issue

JoMoore__GISP · Answer

Thank You Dan,

Its been making my world a little crazy. I think my work around is to

create a separate sorting attribute.

Jo A. Moore, GISP

GIS Specialist

DanPatterson_Retired · Answer

No clue.... "(" comes before "-" in a sorted list of printable characters (determined using python 3.6.8, UTF-8 encoding... I can produce the examples if you want them)

Another one for SDE being itself I suppose