Look up the @CIHPER tag - it support several hash algorisms. Since you are new to it, read it though carefully and do some testing, it can be a little tricky to use.
The items listed as HASH actions, are one-way and can not be undone - SHA is the current standard. The items listed as encrypt/decrypt actions are two-way and can be decryted provided you have the key. Rijndael (aka AES) is the current standard. Robert -----Original Message----- From: Roland Dumas [mailto:[email protected]] Sent: Tuesday, November 24, 2009 11:48 AM To: [email protected] Subject: Re: Witango-Talk: encrypting into mysql thank you. I'm ignorant about these things and need more explicit steps: how does one "hash" a string? There's no <@hash> tag in witango What if you really want the unhashed string back out? Say, a credit card number? On Nov 24, 2009, at 8:17 AM, Beverly Voth wrote: > On 11/24/09 11:08 AM, "Roland Dumas" <[email protected]> wrote in whole or in > part: > >> >> How does one insert a field into a database - mysql - so that it ends up >> encrypted? >> Needless to say, the field must be unencryptable in order to compare it to >> submissions, as in a password, or unencryptable for export, as in a cc number. >> >> How does this work? > > Typically, the data is hashed before INSERT. Then the data to "compare" is > also hashed and the two are compared. You don't need to "un-hash" the stored > information before comparison. > > <http://en.wikipedia.org/wiki/Cryptographic_hash_function> > > Beverly Voth > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
