Link to home
Start Free TrialLog in
Avatar of NormanPinto
NormanPinto

asked on

How to use MySql's convert function?

Hi,

I'm trying to convert binary strings that have been created using aes_encrypt('string','secret') to a text or character string.

I know MySql does this with convert http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html

But can you give me a small example using convert and cast where a binary string is converted to characters or text. The column that stores my binary data is called org_a. What ever i do i don't get any valid output. Just a 2 small exmaples using convert and cast (not aes_decrypt)

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Steve Bink
Steve Bink
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial