Contents Index SCALE option [database] SQL_FLAGGER_ERROR_LEVEL option [compatibility]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

SORT_COLLATION option [database]


Function 

Allows implicit use of the SORTKEY function on ORDER BY expressions.

Allowed values 

INTERNAL, collation_name, or collation_id

Default 

INTERNAL

See also 

SORTKEY function [String]

Description 

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.

Examples 

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

Contents Index SCALE option [database] SQL_FLAGGER_ERROR_LEVEL option [compatibility]