GNU Info

(mysql.info)Hexadecimal values

---

Next: NULL values Prev: Number syntax Up: Literals

---

Enter node , (file) or (file)node

Hexadecimal Values
..................

MySQL supports hexadecimal values.  In number context these act like an
integer (64-bit precision). In string context these act like a binary
string where each pair of hex digits is converted to a character:

     mysql> SELECT 0xa+0;
            -> 10
     mysql> select 0x5061756c;
            -> Paul

Hexadecimal strings are often used by ODBC to give values for BLOB
columns.