HEX() FUNCTION
The MySQL HEX function is used to get a hexadecimal string for the specified string.
Syntax:
HEX( string )
HEX( string )
HEX( string )
Parameters:
string: It is used to specify the string to evaluate.
Example 1:
mysql> SELECT HEX ( ‘A’ );
mysql> SELECT HEX ( ‘A’ );
mysql> SELECT HEX ( ‘A’ );
Output:
41
41
41
Explanation:
The hex code of the string is returned.
Example 2:
mysql> SELECT HEX ( 1 );
mysql> SELECT HEX ( 1 );
mysql> SELECT HEX ( 1 );
Output:
31
31
31
Explanation:
The hex code of the number is returned.