sha1

[alienmojo]

ok im trying to add sha1 hashing into my website i have this code in a scrip that add users to my website and then hashs there password

 

$password=sha1($_POST[password]);

$sql="INSERT INTO users (login, pass)

VALUES

('$_POST[username]','$password')";

 

and say for instance you put "cool" there

it puts this in the database

 

85d8d76ba15bde3ef160

 

here is the code i have in i have in the login script once you add the user

 

$pass=htmlentities(sha1($_POST["pass"]), ENT_QUOTES);

 

and it hashes it to this

 

85d8d76ba15bde3ef1602f477f32fd64e32fea5a

 

after coping and pasting this in here i realized the problem was when i fist made the table (not knowing that i was going to use sha1) made my pass equal to varchar(20) is there a way to change it to where pass is equal to varchar(255) without loosing all of my data in the collum

[Philip]

mysql query:

ALTER TABLE `tablename` MODIFY `password`  varchar (255);

 

should work