How to get Md5 hash value in SQL Server CE 4.0

Question

How to get MD5 Hash value in SQL Server CE 4.0?

I tried following but I am getting unregognized function for Hashbytes, at SQL Server CE toolbox for Visual Studio

select CONVERT(NVARCHAR(32), HashBytes('MD5', '[email protected]'), 2)

The function is not recognized by SQL Server Compact. [ Name of function = HashBytes,Data type (if known) = ]

ErikEJ · Accepted Answer · 2013-11-26 19:57:27Z

2

The Hashbytes function is not supported in SQL Server Compact, you can use the .NET ComputeHash function instead

answered Nov 26, 2013 at 19:57

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1