MySQL Forums
Forum List  »  General

'FROM_BASE64' Function Returns Hex Value
Posted by: fikri fadzil
Date: September 30, 2013 01:15AM

I just upgraded the MySQL that I am using to MySQL version 5.6.14. When I issued this query,

SELECT FROM_BASE64(TO_BASE64('MySQL'));

I received 4d7953514c (hex value) as the answer instead of 'MySQL'. What is actually the problem? Is there anything that I have to do to unhex it?

NOTE: The UNHEX function in my MySQL also returns the same thing. If a hex value is given to UNHEX function, I will receive the same hex value again.


TQ in advance

Options: ReplyQuote


Subject
Written By
Posted
'FROM_BASE64' Function Returns Hex Value
September 30, 2013 01:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.