Forked from jamesgmarks/gist:56502e46e29a9576b0f5afea3a0f595c
Created
January 11, 2021 23:37
-
-
Save onlineth/154c0aed039479a1f079238c1c37a706 to your computer and use it in GitHub Desktop.
MySQL/MariaDB BIN_TO_UUID and UUID_TO_BIN Polyfill
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DELIMITER // | |
CREATE FUNCTION BIN_TO_UUID(b BINARY(16)) | |
RETURNS CHAR(36) | |
BEGIN | |
DECLARE hexStr CHAR(32); | |
SET hexStr = HEX(b); | |
RETURN LOWER(CONCAT( | |
SUBSTR(hexStr, 1, 8), '-', | |
SUBSTR(hexStr, 9, 4), '-', | |
SUBSTR(hexStr, 13, 4), '-', | |
SUBSTR(hexStr, 17, 4), '-', | |
SUBSTR(hexStr, 21) | |
)); | |
END// | |
CREATE FUNCTION UUID_TO_BIN(uuid CHAR(36)) | |
RETURNS BINARY(16) | |
BEGIN | |
RETURN UNHEX(REPLACE(uuid, '-', '')); | |
END// | |
DELIMITER ; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment