Re: Hashing a character string

Claus Samuelsen wrote: > It's most likely that IDS 9.5 will have this feature standard, That hashing algorithm? I don't think so -- it is pretty feeble. Mechanisms for encrypting data - maybe. If it is provided, you'll have to worry about the key management, since the server won't be doing it for you. Since DB2 already has some column-level encryption stuff, you can take a look at what they provided and there's at least a chance that IDS would provide something somewhat similar. No promises; all design decisions are subject to change. > but you'll have to change SCO to Linux Being careful not to get sued by SCO for doing so! > David Reed wrote: >> We have Informix 7.3 on SCO Unix. >> We would like to encrypt a password in an table without having to >> change the existing applications. >> >> The idea is to make use of a simple hashing method, something like: >> If the current password is 'password' we want to in a trigger and SP >> convert to >> p*1 = x1 >> a*2 = x2 >> s*3 = x3 >> s*4 = x4 >> w*5 = x5 >> o*6 = x6 >> r*7 = x7 >> d*8 = x9 >> >> Giving a new password 'x1x2x3x4x5x6x7x8x9' >> >> The problem, How to a multiply/add something with a character to >> give me a new character? Do you need to recover the actual password, or merely verify that the entered password is the same as the encoded one, with some high degree of reliability? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/