Skip to content

Instantly share code, notes, and snippets.

@ianAndrewClark

ianAndrewClark/MySQL functions to convert between binary and string uuids

Forked from IcyMidnight/MySQL functions to convert between binary and string uuids
Last active December 14, 2015 15:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ianAndrewClark/5108985 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ianAndrewClark/5108985 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. ianAndrewClark revised this gist Apr 23, 2013. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion MySQL functions to convert between binary and string uuids
    View file
    Original file line number Diff line number Diff line change
    @@ -5,7 +5,7 @@ RETURNS CHAR(36) DETERMINISTIC
    BEGIN
    DECLARE hex CHAR(32);
    SET hex = HEX(b);
    RETURN CONCAT(LEFT(hex, 8), '-', MID(hex, 9,4), '-', MID(hex, 13,4), '-', MID(hex, 17,4), '-', RIGHT(hex, 12));
    RETURN LOWER(CONCAT(LEFT(hex, 8), '-', MID(hex, 9,4), '-', MID(hex, 13,4), '-', MID(hex, 17,4), '-', RIGHT(hex, 12)));
    END
    |

  2. damienb renamed this gist Aug 17, 2009. 1 changed file with 0 additions and 0 deletions.
    0 ...convety binary UUID to formatted hex UUID → ...o convert between binary and string uuids
    View file
    File renamed without changes.
  3. damienb revised this gist Aug 17, 2009. 1 changed file with 9 additions and 1 deletion.
    10 changes: 9 additions & 1 deletion MySQL Function to convety binary UUID to formatted hex UUID
    View file
    Original file line number Diff line number Diff line change
    @@ -1,9 +1,17 @@
    DELIMITER |

    CREATE FUNCTION uuid_from_bin(b BINARY(16))
    RETURNS CHAR(36) DETERMINISTIC
    BEGIN
    DECLARE hex CHAR(32);
    SET hex = HEX(b);
    RETURN CONCAT(LEFT(hex, 8), '-', MID(hex, 9,4), '-', MID(hex, 13,4), '-', MID(hex, 17,4), '-', RIGHT(hex, 12));
    END|
    END
    |

    CREATE FUNCTION uuid_to_bin(s CHAR(36))
    RETURNS BINARY(16) DETERMINISTIC
    RETURN UNHEX(CONCAT(LEFT(s, 8), MID(s, 10, 4), MID(s, 15, 4), MID(s, 20, 4), RIGHT(s, 12)))
    |

    DELIMITER ;
  4. damienb created this gist Jul 31, 2009.
    9 changes: 9 additions & 0 deletions MySQL Function to convety binary UUID to formatted hex UUID
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,9 @@
    DELIMITER |
    CREATE FUNCTION uuid_from_bin(b BINARY(16))
    RETURNS CHAR(36) DETERMINISTIC
    BEGIN
    DECLARE hex CHAR(32);
    SET hex = HEX(b);
    RETURN CONCAT(LEFT(hex, 8), '-', MID(hex, 9,4), '-', MID(hex, 13,4), '-', MID(hex, 17,4), '-', RIGHT(hex, 12));
    END|
    DELIMITER ;