autoId (128 bits) vs varchar(64)

Question

autoId (128 bits) vs varchar(64)

Ricardo1980 opened this issue 5 years ago · 2 comments

Ricardo1980 commented 5 years ago

Hello,

I see in the resolvers you use autoId, which returns a 128 bit uuid, or a 16 characters string.
However, in the SQL crearion statements, I see that the id type is varchar(64).
Shouldn’t that be varchar(16) or binary(16)?

Thanks.

Answer 1 · 2019-12-09T18:08:17.000Z

Feel free to optimize the sample further if the larger varchar size feels unnecessary.

Answer 2 · 2019-12-13T23:41:01.000Z

I'm using BINARY(16) with UNHEX and HEX (alias), and everything is working fine.
Don't forget to remove the hyphens .