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
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
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.
