MySQL
keyboard_arrow_down 295 guides
chevron_leftString
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
Comment auto_stories Bi-column layout
settings
MySQL | UNHEX method
schedule May 20, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
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
Comment
Citation
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!
