From: Johan De Meersman Date: September 17 2010 12:11pm Subject: Re: Encryption with MYSQL List-Archive: http://lists.mysql.com/mysql/223023 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cd52e70e5473a0490737433 --000e0cd52e70e5473a0490737433 Content-Type: text/plain; charset=ISO-8859-1 Simply base64-encode the returned binary string before offering it to your client. On Fri, Sep 17, 2010 at 1:22 PM, Tompkins Neil 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 --000e0cd52e70e5473a0490737433--