Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

Convert a string or a number to a string in hexadecimal format with the HEX() function

mysql> mysql> SELECT HEX('cat'); +------------+ | HEX('cat') | +------------+ | 636174     | +------------+ 1 row in set (0.02 sec) mysql> mysql> SELECT 0x636174; +----------+ | 0x636174 | +----------+ | cat      | +----------+ 1 row in set (0.00 sec) mysql>