The return values have the meanings shown in the following table. Lower values have higher precedence.
CoercibilityMeaning
0Explicit collation
1No collation
2Implicit collation
3System constant
4Coercible
5Ignorable
mysql>
mysql> SELECT COERCIBILITY('abc' COLLATE latin1_swedish_ci);
+-----------------------------------------------+
| COERCIBILITY('abc' COLLATE latin1_swedish_ci) |
+-----------------------------------------------+
| 0 |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql>