Sorting in Appian Grid

We are trying to validate the Sorting on Grid Columns

For this we are fetching the data of the column from DOM using web scraping

Example:

Column1: "Apple", "Apple1", "Apple0", "Apple_"

on sorting the Grid (say in Descending Order)

We get:

Column1: "Apple1", "Apple0", "Apple_", "Apple"

Which tells us that the order of preference when sorting is:

'1' > '0' > '_' > ''

But the ASCII values are:

Character        -        ASCII Value

1                -         49

0                -         48

_                -         95

Hence going by ASCII Values

'_' must have the highest preference

and the sorted column data must be

Column1: "Apple_", "Apple1", "Apple0", "Apple"

Does anyone know what could be the reason behind it?

Does Appian Sort by ASCII Characters or it has some other methodology ?

Thank you