MySQL tutorial: COERCIBILITY [EN]
top of page
CerebroSQL

MySQL: 

COERCIBILITY

Syntax:
COERCIBILITY(str)

Returns the collation coercibility value of the string argument.

URL: https://dev.mysql.com/doc/refman/8.0/en/information-functions.html

Example

mysql> SELECT COERCIBILITY('abc' COLLATE utf8_swedish_ci);
-> 0
mysql> SELECT COERCIBILITY(USER());
-> 3
mysql> SELECT COERCIBILITY('abc');
-> 4
mysql> SELECT COERCIBILITY(1000);
-> 5

bottom of page