4 ms·
Fun improvement from my project a long time ago, uuid has 36 char and to save space, we created a shorten version by removing all the dash character in uuid. Th
by lepetitchef 5y ago
Fun improvement from my project a long time ago, uuid has 36 char and to save space, we created a shorten version by removing all the dash character in uuid. The result is 4 char could be removed, the field in MySQL table only needs 32 char.
- isoprophlex 5y agoThe point is, a uuid contains 128 bits of data, so a varchar(32) is still somewhat excessive
- Too 5y agoWhy varchar over char? The length is always the same.
- isoprophlex 5y agoYeah, true. My bad. I'm used to calling everything TEXT.