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






  1. MySQL Tutorial
  2. Information Functions
  3. COERCIBILITY

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');