This is an extension of the Resolved issue to include characters prefixed with an underscore "_" commonly used to promote sorting on characters.
Using a modified test case from that Jira.
The sort order for “_A,_B,_C” was correct in Lucee 22.214.171.124
I've checked this ticket with both affected and lucee latest version 126.96.36.199-SNAPSHOT.
Seems, Lucee result is as same as ACF.
will confirm it.
, I suspect that the sort order on ACF is incorrect then. Underscores should be ahead of standard characters, when order by is ascending.
Just as you would expect with SQL:
The results would be