HEX(UNHEX('1267')); : UNHEX « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. UNHEX
mysql>
mysql>
mysql> SELECT HEX(UNHEX('1267'));
+--------------------+
| HEX(UNHEX('1267')) |
+--------------------+
| 1267               |
+--------------------+
1 row in set (0.02 sec)








23.46.UNHEX
23.46.1.UNHEX(str) interprets each pair of hexadecimal digits as a number and converts it to the character
23.46.2.UNHEX(HEX('string'));
23.46.3.HEX(UNHEX('1267'));
23.46.4.UNHEX('GG');