April 26, 2017 at 3:01 pm
hi,
From below calculation for hashbytes do you see any difference? When i try to run the calculated value for this changes. I am kind of struck here , unable to see what difference does the string has that giving me different values for both other than lower and upper case string.
select CONVERT(BIGINT, Hashbytes('SHA1','BESTBUY' + 'Audiovox 8500 Virgin Mobile Silver'))
select CONVERT(BIGINT, Hashbytes('SHA1','BESTBUY'+ 'AUDIOVOX 8500 VIRGIN MOBILE SILVER'))
April 26, 2017 at 3:20 pm
Can't find anything, but it looks like hashbytes may be actually treat string inputs as case sensitive.
April 28, 2017 at 8:53 am
I'm pretty sure any kind of HASH function is going to operate on the binary value of a character, so lower case a (ASCII 96) is going to hash differently than upper case A (ASCII 65).
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply