Underscores do not sort correctly when sorting data
Operating system version
Description of the issue
When sorting data (language English), the underscore character is ignored rather than sorting to the top as it "normally" does (e.g. in Excel, the Finder, and even FileMaker's own Manage Fields dialog).
Steps to reproduce the problem
Create a database with a single text field. Create three records in the database, entering into the text field:
Then sort the three records based on that field.
The records should sort as:
The records sort as though the underscore were not present, that is:
Exact text of any error message(s) that appear
OS is configured as English, English is the default language in FileMaker as well.
In the sort dialog, if I override the field's language to Unicode, the underscore is at least not ignored, but it sorts to the bottom rather than to the top.
If I create a calc field that returns the first field in lowercase, then sort *that* in Unicode, I get the desired result, but this workaround comes with a performance and ease-of-use hit that I'd like to avoid.