>I've been playing around lately with hashing via both SQL Server 2008 and
>CF. The following should give you the same results in both:
>
><cfset hashpwd = hash(pwd & uuid,"SHA-1" )>
>
>SET @pwdHash = CONVERT(VARCHAR(40),HashBytes('SHA1', @pwd + @UUID),2)
>
>My understanding is, SQL Server 2012 is the only version that currently
>supports SHA512.
>
>Thanks,
>
>Eric Cobb
>http://www.cfgears.com
>
>In the example it was a hardcoded string for the salt. 'mySalt'. you'd
>just replace that with whatever you intend to use.
>
>I haven't used SHA512 this way. I only did it the way I did so there was
>an equivalent method in CF to generate the same hash.
>
>You'd have to play around with generating SHA512 hashes in TSQL and make
>sure you are also able to generate that same hash in CF (assuming you will
>be doing your hashing in CF at all before sending to the database).
>
>You can do as many iterations of the salt as you want I suppose. If I was
>going to hash multiple times, I'd salt them all.
>
>On 3/11/13 9:05 AM, "Torrent Girl" <moniqueb...@gmail.com> wrote:
>
>>SHA512
Thanks. Is there any benefit to using SHA512 over anything else?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354937
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
