Simply base64-encode the returned binary string before offering it to your
client.
On Fri, Sep 17, 2010 at 1:22 PM, Tompkins Neil <neil.tompkins@stripped
> wrote:
> Hi,
>
> I need to encrypt a string like 'hello world', using a passkey. But I also
> need to be able to decrypt the encrypted phrase using the same passkey. I
> noticed in MySQL there are functions like
> AES_ENCRYPT()<
>
> http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_aes-encrypt
> >
>
> However, I need the encrypted phrase to be returned as a string, since it
> will be passed to a URL as a parameter. Does anyone have any suggestions
> on
> how to overcome this issue, using MySQL.
>
> I know that there are many components available out there, but I can't
> install any third party components on the hosting server.
>
> Cheers
> Neil
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel