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






  1. MySQL Tutorial
  2. String Functions
  3. HEX
mysql>
mysql>
mysql> SELECT HEX(CHAR(1,0,0)), HEX(CHAR(256*256));
+------------------+--------------------+
| HEX(CHAR(1,0,0)) | HEX(CHAR(256*256)) |
+------------------+--------------------+
| 010000           | 010000             |
+------------------+--------------------+
1 row in set (0.02 sec)

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