Different HashBytes Value

• moorthy.jy

  SSCommitted

  Points: 1753

  More actions

  December 10, 2011 at 10:41 pm

  #251779

  Hi,

  Currently, i am working on 2005 Encryption on our history data, which has many millions of rows with sensitive data. I am fine with Encryption. But, having problem with searches using FrontEnd application. I have decided to go with HashBytes for giving search on the sensitive data. When i test hash, it's generating different values. Which is correct or which method is better to choose ?

  DECLARE @CRD CHAR(19)

  SET @CRD = '1234567890123456'

  SELECT CONVERT(BINARY(20), HashBytes('SHA1', @CRD))

  SELECT CONVERT(BINARY(20), HashBytes('SHA1', '1234567890123456'))

  Thanks,

  Moorthy

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  December 11, 2011 at 3:57 am

  #1419782

  Try the same code with VARCHAR datatype. It should work.

  DECLARE @CRD VARCHAR(19) -- Replaced CHAR(19) with VARCHAR(19)

  SET @CRD = '1234567890123456'

  SELECT CONVERT(BINARY(20), HashBytes('SHA1', @CRD))

  SELECT CONVERT(BINARY(20), HashBytes('SHA1', '1234567890123456'))

• moorthy.jy

  SSCommitted

  Points: 1753

  More actions

  December 11, 2011 at 11:19 pm

  #1419861

  Thanks Dev. I didn't think about it.