Re: Encryption with MYSQL

Hi, On Mon, Sep 20, 2010 at 4:59 AM, Tompkins Neil wrote: > Any ideas why my statement like SELECT SHA1('abc') AS my_sha is being > returned as binary value, I thought it should be returning HEX in anycase ? Maybe because that's what it's intended to do. http://dev.mysql.com/doc/refman/5.1/en/en

Re: Encryption with MYSQL

Any ideas why my statement like SELECT SHA1('abc') AS my_sha is being returned as binary value, I thought it should be returning HEX in anycase ? I'm using MySQL community server 5.1.43, with Innodb tables. Cheers Neil On Sat, Sep 18, 2010 at 10:43 AM, Johan De Meersman wrote: > hex() and unhex

Re: Encryption with MYSQL

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.

Encryption with MYSQL

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()