Mega Code Archive

 

Categories / MySQL Tutorial / Information Functions

 

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