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

MySQL TUTORIALS » 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>