Different checksum HASH_MD5 in SQLA and BTEQ

General

Different checksum HASH_MD5 in SQLA and BTEQ

select hash_md5('     1.|     1.|  0.|33|22|520|      .00|      .00| 0.| 0.|S|¦|A|   1.|N|Y|      .00|   0.|   0.|      .00|¦|P|¦|59514|N|RAMORAN|A|A|19000101|19000101');

--SQLA
E56ED29893E6C9FB9A58EA056A1AD736

--BTEQ
43081B5DBF6C2147E530844CCB0A42CD

I am not sure why but i get different checksum values for the same string in BTEQ and SQL Assistant.

Could guys please help

1 REPLY

Re: Different checksum HASH_MD5 in SQLA and BTEQ

I debugged it further and found the function does not behave the same with EXTENDED ASCII chars in the input