MySQL Tutorial/Information Functions/COLLATION
Версия от 16:44, 26 мая 2010; (обсуждение)
COLLATION(str) returns the collation of the string argument.
<source lang="sql">
mysql> mysql> SELECT COLLATION("abc"); +-------------------+ | COLLATION("abc") | +-------------------+ | latin1_swedish_ci | +-------------------+ 1 row in set (0.00 sec)</source>
SELECT COLLATION(_utf8"abc");
<source lang="sql">
mysql> mysql> mysql> SELECT COLLATION(_utf8"abc"); +-----------------------+ | COLLATION(_utf8"abc") | +-----------------------+ | utf8_general_ci | +-----------------------+ 1 row in set (0.00 sec)</source>