Data Types MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Data Types
  4. 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>