How does sorting in ANSI mode differ from sorting in BTET mode?

Database
N/A

How does sorting in ANSI mode differ from sorting in BTET mode?

How does sorting in the ANSI transaction mode differ from the sorting in the BTET transaction mode? Especially, sorting of the spaces, numbers in a varchar column.
I observed that for a query which is run in the Queryman has a different sorting from what it is when the same query is run through a mainframe job.

Thanks in advance!
Regards