MySQL Tutorial/Information Functions/COERCIBILITY

COERCIBILITY(str) returns the collation coercibility value of the string argument.

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

Coercibility Meaning 0 Explicit collation 1 No collation 2 Implicit collation 3 System constant 4 Coercible 5 Ignorable

mysql>
mysql> SELECT COERCIBILITY("abc" COLLATE latin1_swedish_ci);
+-----------------------------------------------+
| COERCIBILITY("abc" COLLATE latin1_swedish_ci) |
+-----------------------------------------------+
|                                             0 |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql>
mysql>

SELECT COERCIBILITY("abc");

mysql>
mysql>
mysql> SELECT COERCIBILITY("abc");
+---------------------+
| COERCIBILITY("abc") |
+---------------------+
|                   4 |
+---------------------+
1 row in set (0.00 sec)

SELECT COERCIBILITY(USER());

mysql>
mysql> SELECT COERCIBILITY(USER());
+----------------------+
| COERCIBILITY(USER()) |
+----------------------+
|                    3 |
+----------------------+
1 row in set (0.00 sec)
mysql>