SELECT 0xa+0; : hexadecimal « Data Types « MySQL Tutorial






  1. MySQL Tutorial
  2. Data Types
  3. hexadecimal
mysql>
mysql>
mysql>
mysql> SELECT 0xa+0;
+-------+
| 0xa+0 |
+-------+
|    10 |
+-------+
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