collation function
Preview
This feature is in Public Preview.
Applies to:  Databricks SQL 
 Databricks Runtime 16.1 and above
Returns the collation attached to strExpr.
Syntax
collation (strExpr)
Arguments
- strExpr: A- STRINGexpression.
Returns
A STRING using default collation, with the collation name.
Examples
SQL
> SELECT collation('test');
 UTF8_BINARY