Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL HashBytes sometimes adds trailing zeroes RE: HashBytes sometimes adds trailing zeroes

  • December 28, 2017 at 11:27 am

    #1973738

    WilburSmith - Thursday, December 28, 2017 11:14 AM

    Hi,

    OK. Binary(16) would solve the problem. There is only one minor problem...there is a big DataVault solely based on varbinary(40) fields - too big a job to start changing data types and Informatica loads...

    Truncation in the load is not the case, all fports are varbinaru(40)

    Thnaks, Ville

    This value: 0xB54E921E9BF81A19E76D8D15D16AD000, is 16 bytes.  HASHBYTES did NOT add trailing bytes to the value.  If the final two zeros are being dropped, it is not HASHBYTES causing the problem.  I get the same value whether I run HASHBYTES alone or cast it VARBINARY(40).