The default type of a hexadecimal value is a string : hexadecimal « Data Types « MySQL Tutorial






  1. MySQL Tutorial
  2. Data Types
  3. hexadecimal
mysql>
mysql> SELECT 0x41, CAST(0x41 AS UNSIGNED);
+------+------------------------+
| 0x41 | CAST(0x41 AS UNSIGNED) |
+------+------------------------+
| A    |                     65 |
+------+------------------------+
1 row in set (0.00 sec)








10.13.hexadecimal
10.13.1.How 0x00-padding of BINARY values affects column value comparisons:
10.13.2.SELECT 0xa+0;
10.13.3.SELECT 0x5162766c;
10.13.4.The default type of a hexadecimal value is a string
10.13.5.Convert a string or a number to a string in hexadecimal format with the HEX() function