Hi All,
I'm facing an issue with RAWTOHEX value function where it is generating different values for the same input on two different database versions i.e. Oracle 11.2.0.1.0 Enterprise Edition and Oracle 12.1.0.2.0 Enterprise Edition.
[b]Oracle 12.1.0.2.0[/b]
select rawtohex( 'š‡ÏAï®À') FROM DUAL ;
C5A1E280A1C38F41C3AFC2AEC38012
[b]Oracle 11.2.0.1.0[/b]
select rawtohex( 'š‡ÏAï®À') FROM DUAL ;
9A87CF41EFAEC012
Please help me to understand why the output values are different in two different oracle versions. Ideally same value should have been returned.
Thanks & Regards
Manoj