CAST CAST (… AS CHAR(<length>)) CONVERT() CAST CAST() CAST CAST (… AS CHAR()) CAST() https://dev.mysql.com/doc/refman/5.7/en ... on_convert http://dev.mysql.com/doc/refman/5.7/en/cast-functions.html CAST (… AS CHAR()) CAST() BINARY