HEX
Description
If the input parameter is a number, return the string representation of the hexadecimal value.
If the input parameter is a string, convert each character to two hexadecimal characters, concatenate all the converted characters into a string for output.
Syntax
HEX ( <str> )Parameters
| Parameter | Description |
|---|---|
<str> | Input parameter is a number or a string |
Return value
The hexadecimal result of parameter <str>.
Example
The input parameter is a number
SELECT HEX(12),HEX(-1)+---------+------------------+
| hex(12) | hex(-1) |
+---------+------------------+
| C | FFFFFFFFFFFFFFFF |
+---------+------------------+The input parameter is a string
SELECT HEX('1'),HEX('@'),HEX('12')+----------+----------+-----------+
| hex('1') | hex('@') | hex('12') |
+----------+----------+-----------+
| 31 | 40 | 3132 |
+----------+----------+-----------+