COERCIBILITY(str)

Returns the collation coercibility value of the string argument.

Syntax

MYSQL Copy

SELECT COERCIBILITY('abc' COLLATE utf8mb4_swedish_ci);
0
SELECT COERCIBILITY(USER());
3
SELECT COERCIBILITY('abc');
4
SELECT COERCIBILITY(1000);
5

Examples

Example

The return values have the meanings shown in the following table. Lower values have higher precedence.

MYSQL Copy

SELECT COERCIBILITY('abc' COLLATE utf8mb4_swedish_ci);
0
SELECT COERCIBILITY(USER());
3
SELECT COERCIBILITY('abc');
4
SELECT COERCIBILITY(1000);
5