Main Difference in between UNHEX function and 0x prefix?
Both of above are equal but have little differene in between them
(1)We use 0x prefix with different data columns like char, varchar, text, block, binary etc. And if you are trying to insert an empty string you need to entirely replace with '' another wise you will get error.
(2)On the other hand UNHEX() will works on any of column and no need to worry about empty string. | |