collation function

Preview

This feature is in Public Preview.

Applies to: Databricks SQL check marked yes Databricks Runtime 16.1 and above

Returns the collation attached to strExpr.

Syntax 

collation (strExpr)

Arguments

  • strExpr: A STRING expression.

Returns

A STRING using default collation, with the collation name.

Examples 

> SELECT collation('test');
 UTF8_BINARY