Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

SELECT HEX(CHAR(1,0,0)), HEX(CHAR(256256))

mysql> mysql> SELECT HEX(CHAR(1,0,0)), HEX(CHAR(256*256)); +------------------+--------------------+ | HEX(CHAR(1,0,0)) | HEX(CHAR(256*256)) | +------------------+--------------------+ | 010000           | 010000             | +------------------+--------------------+ 1 row in set (0.02 sec) mysql>