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', '不锈钢平垫Ｍ１０') -- OUTPUT: 0xF2E5A4AF781A8D5DE0007A24E172CA47 SELECT HASHBYTES('MD5', 'ABCDEFGHIJK') -- 0x30A4E38230885E27D1BB3FD0713DFA7D
Query on SAP Hana:
SELECT HASH_MD5(TO_BINARY('不锈钢平垫Ｍ１０')) 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