HEX()¶
Function Description¶
For string parameter str, HEX() returns the hexadecimal string form of str. Where, each byte of each character in str is converted to two hexadecimal numbers (multi-byte characters are converted to more than two numbers).
For the numeric parameter N, HEX() returns the hexadecimal string form of the N value and is converted as an integer. This is equivalent to CONV(N,10,16), and the opposite operation performs CONV(HEX(N),16,10).
For the NULL parameter, this function returns NULL.
Function Syntax¶
> HEX(str), HEX(N)
Parameter definition¶
Parameters |
Description |
|---|---|
N |
Required parameters. To convert to hexadecimal number. |
str |
Required parameters. A string, whose character is converted to two hexadecimal numbers. |
Example¶
> 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)