Insert an md5 password in mssql

To md5 a string in mssql we execute this query:
select HASHBYTES('MD5', 'password')

//But this has a problem because it returns a VarBinary data type which is a garbled text. So it should be converted first to NVarchar:
SELECT CONVERT(NVARCHAR(32),HashBytes('MD5', 'password'),2)

//To insert in the database
insert into Users (username, password) values ('user', (SELECT CONVERT(NVARCHAR(32),HashBytes('MD5', 'password'),2)))
Insert an md5 password in mssql Insert an md5 password in mssql Reviewed by Edward Legaspi on Tuesday, November 08, 2011 Rating: 5

1 comment:

Anonymous said...

Thanks it was helpful

Powered by Blogger.