CONVERT(... USING ...) is implemented according to the standard SQL specification.You may also use CAST() to convert a string to a different character set. The syntax is:CAST(character_string AS character_data_type CHARACTER SET charset_name)Example:SELECT CAST(_latin1'test' AS CHAR CHARACTER SET utf8); 手册上说,可以对字段转!
convert()是用来进行类型转换的,字符串连接是concat()
SELECT CAST(_latin1'test' AS CHAR CHARACTER SET utf8); 用cast可以?latin1'test' AS CHAR CHARACTER SET utf8 latin1'test' 字段?
手册上说,可以对字段转!
SELECT CAST(_latin1'test' AS CHAR CHARACTER SET utf8); 用cast可以?latin1'test' AS CHAR CHARACTER SET utf8
latin1'test' 字段?