ASA Database Administration Guide
Database Options
Alphabetical list of options
Allows implicit use of the SORTKEY function on ORDER BY expressions.
INTERNAL, collation_name, or collation_id
INTERNAL
When the value of this option is INTERNAL, the ORDERBY clause remains unchanged.
When the value of this option is set to a valid collation name or collation ID, any string expression in the ORDER BY clause is treated as if the SORTKEY function had been invoked.
Set the sort collation to binary:
set temporary option sort_collation='binary'
Having the sort collation set to binary transforms
SELECT name, id FROM product ORDER BY name, id
and
SELECT name, id FROM product ORDER BY 1,2
into
SELECT name, id FROM product ORDER BY SORTKEY(name, 'binary'), id