Google Sheets strings comparator

Question

Could anyone tell what exact strings comparing algorithm is used in Google Sheets?

I try to use an array of data sorted by Google Sheets and seems that it's not usable for binary search. For example, Google Sheets thinks that

0(48) > |(124)

-(45) > _(95)

and so on.

Thanks in advance!

Answer 1

The problem is solved. I had to create a map of ASCII -> Google Sheet indices and apply it in my own comparator. Thanks to @I'-'I for sharing "possible duplicate" to Google Sheets character sort order