Skip to main content
Version: 2.5

hex

Description​

If x is a numerical value, this function returns a hexadecimal string representation of the value.

If x is a string, this function returns a hexadecimal string representation of the string where each character in the string is converted into two hexadecimal digits.

Syntax​

HEX(x);

Parameters​

x: the string or number to convert. The supported data types are BIGINT and VARCHAR.

Return value​

Returns a value of the VARCHAR type.

Examples​

mysql> select hex(3);
+--------+
| hex(3) |
+--------+
| 3      |
+--------+
1 row in set (0.00 sec)

mysql> select hex('3');
+----------+
| hex('3') |
+----------+
| 33       |
+----------+
1 row in set (0.00 sec)

mysql> select hex('apple');
+--------------+
| hex('apple') |
+--------------+
| 6170706C65   |
+--------------+

Keywords​

HEX