How do I calculate the equivalent to SQL Server (hashbytes(‘SHA1’,[ColumnName])) in C#?

by

You’re likely getting bitten by character encoding differences:

http://weblogs.sqlteam.com/mladenp/archive/2009/04/28/Comparing-SQL-Server-HASHBYTES-function-and-.Net-hashing.aspx

You could try getting the bytes via Encoding.ASCII.GetBytes(url) or Encoding.Unicode.GetBytes(url) and see which one your db is using.

More Related Contents:

  1. Procedure or function xxxxx has too many arguments specified [duplicate]
  2. How to pass an array into a SQL Server stored procedure
  3. Remove weird characters ( A with hat) from SQL Server varchar column
  4. SQL error: Incorrect syntax near the keyword ‘User’
  5. What represents a double in sql server?
  6. Passing List to SQL Stored Procedure
  7. Use of SqlParameter in SQL LIKE clause not working
  8. WHERE IN (array of IDs)
  9. SQL: Update a row and returning a column value with 1 query
  10. Generate class from database table
  11. Passing array to a SQL Server Stored Procedure
  12. Generating sql code programmatically
  13. What does a timestamp in T-Sql mean in C#?
  14. summing values of a column based on id [closed]
  15. How to get last inserted id?
  16. MSSQL Error ‘The underlying provider failed on Open’
  17. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  18. How to monitor SQL Server table changes by using c#?
  19. What is the connection string for localdb for version 11
  20. SqlConnection SqlCommand SqlDataReader IDisposable
  21. SqlBulkCopy from a List
  22. SqlConnection.Close() inside using statement
  23. ExecuteScalar vs ExecuteNonQuery when returning an identity value
  24. Accessing directly a Sql Server Database in Xamarin.Forms
  25. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  26. “The operation is not valid for the state of the transaction” error and transaction scope
  27. How do I safely store database login and password in a C# application?
  28. Bulk Insert Sql Server millions of record
  29. Loading PictureBox Image From Database
  30. EF Core takes a lot of time, sometimes, to perform SELECT query

Leave a Comment