MySQL Tutorial/String Functions/HEX

HEX("abc");

   <source lang="sql">

mysql> mysql> mysql> SELECT HEX("abc"); +------------+ | HEX("abc") | +------------+ | 616263 | +------------+ 1 row in set (0.00 sec) mysql></source>

HEX(N_or_S)

If N_or_S is a number, returns a string representation of the hexadecimal value of N.

If N_or_S is a string, returns a hexadecimal string representation of N_or_S where each character in N_or_S is converted to two hexadecimal digits.

   <source lang="sql">

mysql> mysql> SELECT HEX(255); +----------+ | HEX(255) | +----------+ | FF | +----------+ 1 row in set (0.00 sec) mysql></source>

SELECT HEX(CHAR(1,0,0)), HEX(CHAR(256*256));

   <source lang="sql">

mysql> 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> mysql></source>

SELECT HEX(CHAR(1,0)), HEX(CHAR(256));

   <source lang="sql">

mysql> mysql> mysql> SELECT HEX(CHAR(1,0)), HEX(CHAR(256)); +----------------+----------------+ | HEX(CHAR(1,0)) | HEX(CHAR(256)) | +----------------+----------------+ | 0100 | 0100 | +----------------+----------------+ 1 row in set (0.00 sec) mysql></source>