HEX()

Description

For a string argument str, HEX() returns a hexadecimal string representation of str where each byte of each character in str is converted to two hexadecimal digits. (Multibyte characters therefore become more than two digits.)

For a numeric argument N, HEX() returns a hexadecimal string representation of the value of N treated as an integer number. This is equivalent to CONV(N,10,16). The inverse of this operation is performed by CONV(HEX(N),16,10).

For a NULL argument, this function returns NULL.

Syntax

> HEX(str), HEX(N)

Arguments

Arguments	Description
N	Required. A number which is to be converted to hexadecimal.
str	Required. A string whose each character is to be converted to two hexadecimal digits.

Examples

> SELECT HEX('abc');
+----------+
| hex(abc) |
+----------+
| 616263   |
+----------+
1 row in set (0.00 sec)

> SELECT HEX(255);
+----------+
| hex(255) |
+----------+
| FF       |
+----------+
1 row in set (0.00 sec)