AnsweredAssumed Answered

Is there a way to make sort order consistent?

Question asked by anothersmurf on Sep 2, 2014
Latest reply on Sep 4, 2014 by user19752

When I'm in Manage Database-->Fields and I sort by fieldname, I see all the fields that begin with an underscore on top, followed by fields that start with A, B, etc. But when I'm viewing records in a portal and I sort by one of the fields in the portal, the records in the portal are sorted as though underscores don't exist at all, e.g. A, _B, C.


I'd like records sorted in a portal to be sorted the same way as fieldnames sorted in Manage Database. I know this can be done by calculating a seperate "sort by" field, but I'd like to avoid that for performance reasons. I've tried changing the sort langauge from English/Default to Unicode, but Unicode puts underscores at the bottom not the top (though at least that keeps them together!). Does anyone know the sort language that's used in Manage Database? Or does one of the myriad languages supported by FMP sort like English alpha but with underscores on top?