Skip to Content
0
Jun 12, 2022 at 01:29 PM

Hash Value comparison for Encoded characters not matching between HANA and Azure SQL DB

128 Views

I am working on comparing Hash Values on SAP Hana Data and Azure SQL DB Data. However, it seems Data with special/encoded characters is returning different hash values on SAP Hana DB and SQL DW, even though the Values are same.

Query on Azure SQL DB:

SELECT HASHBYTES('MD5', '不锈钢平垫M10')
-- OUTPUT: 0xF2E5A4AF781A8D5DE0007A24E172CA47

SELECT HASHBYTES('MD5', 'ABCDEFGHIJK')
-- 0x30A4E38230885E27D1BB3FD0713DFA7D

Query on SAP Hana:

SELECT HASH_MD5(TO_BINARY('不锈钢平垫M10')) FROM DUMMY
-- OUTPUT: 0xB5C6519A1F1506431540CFF5980490B4

SELECT HASH_MD5(TO_BINARY('ABCDEFGHIJK')) FROM DUMMY
-- 0x30A4E38230885E27D1BB3FD0713DFA7D

Same is the case with SHA256 algo as well

Require support in handling the encoded/special characters with Hashing