关于sqlserver hashbytes的用法,求解!
现在有user表一张
SELECT hashbytes('SHA1',LoginID)
FROM TB_Frame_User
WHERE loginid = 'test1001'
----------
SELECT LoginID
FROM TB_Frame_User
WHERE loginid = 'test1001'
--------------
SELECT hashbytes('SHA1', 'test1001')
为什么得到的结果不一样,结果分别是如下所示,理论上应该结果1和结果3是一样的啊,都是0x2E3822B99FED1F5EFC012D52B1FF14CC5C85B981才对,LoginID列是nvarchar 50,求解!
0xD87D37B0880EBED2E90BF9E8E52641C3A28CC2DF
test1001
0x2E3822B99FED1F5EFC012D52B1FF14CC5C85B981