Mega Code Archive

 

Categories / MySQL Tutorial / Cast Functions Operators

 

Converting the string abc in the default character set to the corresponding string in the utf8 character set

mysql> mysql> SELECT CONVERT('abc' USING utf8); +---------------------------+ | CONVERT('abc' USING utf8) | +---------------------------+ | abc                       | +---------------------------+ 1 row in set (0.00 sec) mysql>