Hello,I have a field in my database that contains a MD5 hash that was generated in c#. The code that generated it: public string ComputeHash(string str) { private static readonly HashAlgorithm _hashProvider = new MD5CryptoServiceProvider(); byte[] hash = _hashProvider.ComputeHash(_encoding.GetBytes(str)); StringBuilder sbHashCode = new StringBuilder(); foreach (byte theByte in hash) { sbHashCode.AppendFormat("{0:X}", theByte); } return sbHashCode.ToString(); }I have tried to generate the same hash using sql server:SELECT HashBytes('MD5', Value) FROM tTableHowever the two hashes generated from the same string do not match. Does anybody know what I may be doing wrong for the hashes not to match?
Sql MD5 hash doesn't match C# MD5 hash
Posted - 2009-03-27 : 07:36:26
