SQL Server HASHBYTES different values

Question

I want to get the SHA1 Hash of MATKHAU in SQL Server 2019 so I use HASHBYTES. But as you see the value of SELECT HASHBYTES is different from the value when I use Store Procedure. What's wrong with it? (It's the same input in MATKHAU)

Lukasz Szozda · Accepted Answer · 2020-09-18 15:36:39Z

1

Data types matter:

SELECT HASHBYTES('SHA1', '123');   -- here VARCHAR
vs
SELECT HASHBYTES('SHA1', N'123');  -- here NVARCHAR

The stored procedure takes parameter as NVARCHAR which causes implicit conversion when providing parameter to EXEC.

db<>fiddle demo

answered Sep 18, 2020 at 15:36

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

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

2 Comments

Quyên Nguyễn Over a year ago

Thanks. Finally can fix it

Lukasz Szozda Over a year ago

@QuyênNguyễn Glad to hear that. How does accepting an answer work?

Collectives™ on Stack Overflow

SQL Server HASHBYTES different values

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related