Search code examples
mysqlnode.jssequelize.jsuuid

How to properly convert uuid to BINARY(16)?

I have an id field of type BINARY(16) in a mysql table.

I generate the following id: 66e2105c-bff5-4206-a9cc-e212f5622368

With this code:

const v = uuidV4Bytes(16);

The insert via sequalize is: 

INSERT INTO SPORTS(Id,Name,HouseId,Date,Active)
        VALUES ('66e2105c-bff5-4206-a9cc-e212f5622368','SPORTNAME',1, '2020-05-04', 0)

Problem:

Error Code: 1406. Data too long for column 'Id' at row

Im trying to convert a uuid to a binary(16) but apperently Im getting a value that is to big. How do I solve this?

Solution

  • as long as it's always in the form 8-4-4-4-12 hex characters, you could just have MySQL do it for you with REPLACE() and UNHEX()

    INSERT INTO SPORTS(Id,Name,HouseId,WDate,Active)
    VALUES (UNHEX(REPLACE('66e2105c-bff5-4206-a9cc-e212f5622368','-','')),'SPORTNAME',1, '2020-05-04', 0)