Link to home
Start Free TrialLog in
Avatar of NormanPinto

asked on

How to use MySql's convert function?


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

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)

Avatar of Steve Bink
Steve Bink
Flag of United States of America image

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