Ask a question:
Have a Chinese string using the database with function HASHBYTES sha1 get with the program of

No Chinese language and the string using the database with function HASHBYTES get sha1 and procedures, database collation is used Chinese_PRC_CI_AS

How to adjust the SQL to make HASHBYTES results consistent with the calculation results,
Ask for advice

CodePudding user response:

Make a assembly resolved,

CodePudding user response:

I remember to be encrypted string is to distinguish the varchar and nvarchar
The result is not the same