HEX('abc'); : HEX « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. HEX
mysql>
mysql>
mysql> SELECT HEX('abc');
+------------+
| HEX('abc') |
+------------+
| 616263     |
+------------+
1 row in set (0.00 sec)

mysql>








23.15.HEX
23.15.1.HEX(N_or_S)
23.15.2.HEX('abc');
23.15.3.SELECT HEX(CHAR(1,0)), HEX(CHAR(256));
23.15.4.SELECT HEX(CHAR(1,0,0)), HEX(CHAR(256*256));