Issue while generating MD5 if there are any special characters in the CLOB
977132Nov 29 2012 — edited Nov 29 2012Hi Guys,
I need your help...
We are using dbms_crypto.hash to generate the MD5 hash value for a CLOB that will be sent to other feeder systems. The feeder systems validate the file by generating the MD5 hash value on their end and compare with the MD5 generated in Oracle and accept the file only if the MD5 hash value matches.
The MD5 file matches between both the systems except in the case where there are special characters in the CLOB. Somehow, MD5 is prefixing  character before any special character and calculating the MD5 value. In our case, our special characters being ®, §, ™, ©....
This is a high priority issue for us and it is holding our UAT.
We are using Oracle 11.2.0.2.0.
Your response is really appreciated.
Best Regards
Gupta