MySQL HEX() function
HEX() function
MySQL HEX() returns a string representation of a hexadecimal value of a decimal or string value specified as an argument.
If the argument is a string, each character in the argument is converted to two hexadecimal digits.
If the argument is decimal, the function returns a hexadecimal string representation of the argument and treated as a longlong(BIGINT) number.
This function is equivalent to CONV(N,10,16).
Syntax:
HEX (N or S)
Arguments:
Name | Description |
---|---|
N | A number which is to be converted to hexadecimal. |
S | A string whose each character is to be converted to two hexadecimal digits. |
MySQL Version: 5.6
Video Presentation:
Example : MySQL HEX() function
In the following MySQL statement, the argument 157 is a number, which is converted to a hexadecimal number. The output is 9D.
Code:
SELECT HEX(157);
Sample Output:
mysql> SELECT HEX(157); +----------+ | HEX(157) | +----------+ | 9D | +----------+ 1 row in set (0.00 sec)
Example of MySQL HEX() function on character value
In the above MySQL statement, the argument 'Q' is a string. The character of the string is converted to two hexadecimal digits. The output is 51.
Code:
SELECT HEX(‘Q’);
Sample Output:
mysql> SELECT HEX('Q'); +----------+ | HEX('Q') | +----------+ | 51 | +----------+ 1 row in set (0.00 sec)
All String Functions
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework