Re: Troubles with MD5

[Gerald Drake]

If you are using Oracle you have to do a little more legwork to return the 32 character standard that most languages use. I use this function in oracle databases when I need to maintain compatibility. But, you need to start like this, not sure how to convert legacy data.

Create or Replace Function MD5(input_string in VARCHAR2) RETURN VARCHAR2
-- Same Funaction Name as mySQL to maintaing SQL compatibility
IS
hex_digest varchar2(32);
digest varchar2(16);
BEGIN
digest := DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => input_string);
SELECT Lower(RAWTOHEX(digest)) INTO hex_digest FROM dual;
RETURN hex_digest;
END;