Categories:

String & Binary Functions

COLLATION

Syntax

COLLATION(<expression>)

Arguments

expression

The expression for which you want to know the collation specification. Typically, this is a column name.

Returns

Returns a VARCHAR containing the collation specification of the expression.

Examples

This shows how to get the collation specification of the specified column:

select COLLATION(utf8_phrase) from collation_demo;