Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

The default type of a hexadecimal value is a string

mysql> mysql> SELECT 0x41, CAST(0x41 AS UNSIGNED); +------+------------------------+ | 0x41 | CAST(0x41 AS UNSIGNED) | +------+------------------------+ | A    |                     65 | +------+------------------------+ 1 row in set (0.00 sec)