Does Hana support feature similar to NLSSORT?

[Former Member]

Hi,

I can use the following query in Oracle. It will order by the result using the national rules of the given linguistic definition.

select * from testtable order by NLSSORT(testcolumn, 'NLS_SORT=some_linguistic_definition') ASC;

Is there similar feature in SAP Hana? Thank you

[lbreddemann · Accepted solution]

Nope, currently (SPS 10) SAP HANA doesn't support arbitrary sorting collations/locales.

- Lars