(mysql.info.gz) Charset-CAST

Info Catalog

(mysql.info.gz) Charset-CONVERT

(mysql.info.gz) Charset-operations

(mysql.info.gz) Charset-SHOW

 
 10.4.3 `CAST()'
 ---------------
 
 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);
 
 If you use `CAST()' without specifying `CHARACTER SET', the resulting
 character set and collation are defined by the
 `character_set_connection' and `collation_connection' system variables.
 If you use `CAST()' with `CHARACTER SET X', then the resulting
 character set and collation are `X' and the default collation of `X'.
 
 You may not use a `COLLATE' clause inside a `CAST()', but you may use
 it outside. That is, `CAST(... COLLATE ...)' is illegal, but `CAST(...)
 COLLATE ...' is legal.
 
 Example:
 
      SELECT CAST(_latin1'test' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin;
 

Info Catalog

(mysql.info.gz) Charset-CONVERT

(mysql.info.gz) Charset-operations

(mysql.info.gz) Charset-SHOW