SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Caesar-719283 / MD5 / Latest Posts

RE: MD5

Caesar2 — Tue, 03 Nov 2009 05:19:50 GMT

You are totally right...typin' mistake...the 'CAST' is to a NVARCHAR(MAX)I tried a lot whitout that CAST and it returned another 'md5' string... i figure that the problem is in the asigment '@md5 = ...'the sql corrected would be...CREATE FUNCTION [dbo].[fn_MD5]( @string AS VARCHAR(MAX), @chars AS INT)RETURNS NVARCHAR(32)ASBEGIN -- Declare the return variable here DECLARE @md5 NVARCHAR(32) SELECT @md5 = SUBSTRING(CAST(master.dbo.fn_varbintohexstr(HashBytes('MD5',@string )) AS NVARCHAR(MAX)),3,@chars ) -- Return the result of the function RETURN @md5END

RE: MD5

phamminh — Tue, 03 Nov 2009 04:09:56 GMT

You must not use CAST(... AS NVARCHAR(32)), that would remove the 2 last characters-- with SqlServer 2005DECLARE @md5 VARCHAR(32)DECLARE @string varchar(10)SET @string = 'Davolio'SELECT HashBytes('MD5',@string ),master.dbo.fn_varbintohexstr(HashBytes('MD5',@string )),SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5',@string )),3,32 ),SUBSTRING(CAST(master.dbo.fn_varbintohexstr(HashBytes('MD5',@string )) AS NVARCHAR(32)),3,32 )

RE: MD5

Caesar2 — Wed, 14 Oct 2009 10:11:40 GMT

MD5 is a 'one way' algorithm. you can't decrypt it.is very usefull to encrypt passwords, or data that you don't need to read directly.for instance, if i store a md5 string of my password, the system have to compare two md5 strings (password_stored vs MD5(password_wrote)) to verify if my password is correct and letme log in.greets...

RE: MD5

jbinnig — Wed, 14 Oct 2009 10:00:24 GMT

So how do you decrypt it?

MD5

Caesar2 — Fri, 02 Oct 2009 11:13:06 GMT

Comments posted to this topic are about the item [B]MD5[/B]