SELECT HEX(CHAR(1,0)), HEX(CHAR(256)); : HEX « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. HEX
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>








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));