String Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. String Functions
  4. SELECT HEX(CHAR(1,0,0)), HEX(CHAR(256256))
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>