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
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
auto_stories new
settings
MySQL | UNHEX method
Database
chevron_rightMySQL
chevron_rightDocumentation
chevron_rightFunctions
chevron_rightString
schedule Jul 1, 2022
Last updated local_offer MySQL
Tags tocTable of Contents
expand_more Check out the interactive map of data science
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?
thumb_up
thumb_down
Ask a question or leave a feedback...
Official MySQL Documentation
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_unhex
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
