I would agree using mysql, but I think you mean use aes_crypt()
aes_decrypt(), or encode decode, there is no decrypt().
So to insert a record
insert into sometable ('name','somestringname') values
('namevalue',aes_crypt('somestringvalue','somekey'))
Then to retrieve unencrypted:
select name, aes_decrypt(somestringname,'somekey') as somestringname
from sometable where name = 'smith'
something like that.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
rgar...@bighead.net - rgar...@eventpix.com
http://bighead.net/ - http://eventpix.com/
On Nov 24, 2009, at 10:08 AM, John McGowan wrote:
Roland,
Since you mentioned specifically mysql, don't forget that you can do
your encryption with a mysql function call. So you just need to do
a custom column or a direcdbms action.
http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html
you can call encrypt() when doing inserts or updates and call decrypt
() when doing selects
There are other variations, so take a look at the link above and go
from there.
--
/John
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf