Twitter 
Facebook
chevron_left
String
Method ASCIIMethod BINMethod BIT_LENGTHMethod CHARMethod CHAR_LENGTHMethod CHARACTER_LENGTHMethod CONCATMethod CONCAT_WSMethod ELTMethod EXPORT_SETMethod FIELDMethod FIND_IN_SETMethod FORMATMethod FROM_BASE64Method HEXMethod INSERTMethod INSTRMethod LCASEMethod LEFTMethod LENGTHMethod LOAD_FILEMethod LOCATEMethod LOWERMethod LPADMethod LTRIMMethod MAKE_SETMethod MIDMethod OCTMethod OCTET_LENGTHMethod ORDMethod POSITIONMethod QUOTEMethod REPEATMethod REPLACEMethod REVERSEMethod RIGHTMethod RPADMethod RTRIMMethod SOUNDEXMethod SPACEMethod STRCMPMethod SUBSTRMethod SUBSTRINGMethod SUBSTRING_INDEXMethod TO_BASE64Method TRIMMethod UCASEMethod UNHEXMethod UPPERMethod WEIGHT_STRING
0
0
0
new
MySQL | UNHEX method
Database
chevron_rightMySQL
chevron_rightDocumentation
chevron_rightFunctions
chevron_rightString
schedule Mar 9, 2022
Last updated MySQL
Tags tocTable of Contents
expand_more MySQL's UNHEX(~) method returns a binary string from the hexadecimal string representation. For strings, UNHEX(~) is the inverse of the HEX(~) method.
For numeric arguments, the inverse of HEX(~) is performed by CONV(hexadecimal, 16, 10)
NOTE
Hexadecimal is base 16, where there are 16 digits 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, A, B, C, D, E, and F. A through F in hexadecimal is 10 through 15 in decimal notation.
Parameters
1. str | string
The hexadecimal to return the binary string for.
Return value
A binary string representation of the input hexadecimal string.
Examples
To return a binary string from the hexadecimal string '4170706C65':
SELECT UNHEX('4170706C65');
+---------------------+| UNHEX('4170706C65') |+---------------------+| Apple |+---------------------+
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
Ask a question or leave a feedback...
Official MySQL Documentation
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_unhex
