DROP FUNCTION IF EXISTS FNC_CONVERT_CHAR_TO_UUID;

DELIMITER //

CREATE FUNCTION FNC_CONVERT_CHAR_TO_UUID(cID CHAR(36)) RETURNS binary(16)
BEGIN
RETURN CONCAT(REVERSE(UNHEX(LEFT(cID,8))),REVERSE(UNHEX(MID(cID,10,4))),REVERSE(UNHEX(MID(cID,15,4))),UNHEX(MID(cID,20,4)),UNHEX(RIGHT(cID,12)));
END

//
DELIMITER;

DELIMITER $$