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.tompk...@googlemail.com > 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