Hacker News new | ask | show | jobs
by lepetitchef 1623 days 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.
1 comments

The point is, a uuid contains 128 bits of data, so a varchar(32) is still somewhat excessive
Why varchar over char? The length is always the same.
Yeah, true. My bad. I'm used to calling everything TEXT.