COERCIBILITY(str) returns the collation coercibility value of the string argument. : COERCIBILITY « Information Functions « MySQL Tutorial






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>
mysql>








20.4.COERCIBILITY
20.4.1.COERCIBILITY(str) returns the collation coercibility value of the string argument.
20.4.2.SELECT COERCIBILITY(USER());
20.4.3.SELECT COERCIBILITY('abc');