MySQL

SHA1 encription

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2008

Posts: 510

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro

SHA1 encription

Jul 14th, 2008

Hi,

I encrypte my data when i insert into database.

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
INSERT INTO person (name, psw) VALUES ('john',SHA1('111'));
insert into person (name, psw) values ('john',SHA1('111'));

What about when it comes to checking that particular encripted values? Is there any function to use agains SIH-1. I have a textbox and i wanted to verify it with checking encripted data.

Thanks

•

Join Date: Apr 2008

Posts: 296

Reputation: tesuji is on a distinguished road

Solved Threads: 42

tesuji

Offline

Posting Whiz in Training

Re: SHA1 encription

Jul 14th, 2008

So you want to decipher a 160 bit binary HSA1 string? Impossible! (except for hiring some Roadrunner doing brute-force decryption.)

Last edited by tesuji; Jul 14th, 2008 at 4:34 pm.

Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.