COLLATION(str)

MySQL 8.4

Returns the collation of the string argument.

Syntax

MYSQL

SELECT COLLATION('abc');
'utf8mb4_0900_ai_ci'
SELECT COLLATION(_utf8mb4'abc');
'utf8mb4_0900_ai_ci'
SELECT COLLATION(_latin1'abc');
'latin1_swedish_ci'

Examples

Example

MYSQL

SELECT COLLATION('abc');
'utf8mb4_0900_ai_ci'
SELECT COLLATION(_utf8mb4'abc');
'utf8mb4_0900_ai_ci'
SELECT COLLATION(_latin1'abc');
'latin1_swedish_ci'