AES
Posted by:
jas m
Date: January 19, 2008 01:46PM
I am having a problem using AES encryption in mysql...
CREATE TABLE `test` (
`email` blob NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO test (email) VALUES (AES_ENCRYPT('a@b.com', 'pass123'))
SELECT AES_DECRYPT('email', 'pass123') AS email FROM test
The email is always returned as null. I am 99% sure the sql is correct, could it be that I am using an older version of mysql? phpMyAdmin says this:
Server version: 5.0.45-community-nt-log
MySQL client version: 3.23.49
Any ideas? Many thanks :-)
Subject
Views
Written By
Posted
AES
6164
January 19, 2008 01:46PM
3017
January 20, 2008 08:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.