4 ms·
> utf8mb4 comes with some technical "gotchas" (google it) I know InnoDB limits index sizes to 767 bytes, meaning VARCHAR(255) using utf8 can have all 255 chara
by DCoder 10y ago
> utf8mb4 comes with some technical "gotchas" (google it)
I know InnoDB limits index sizes to 767 bytes, meaning VARCHAR(255) using utf8 can have all 255 characters indexed, but VARCHAR(255) using utf8mb4 can only index 191 characters (floor(767/4) == 191).
After a quick Google search, that seems to be the most common gotcha. What other gotchas did you have in mind?
- gotthemwmds 10y agoThis was definitely the first thing that came up, as you found. To be honest, I just don't remember. There was something about something that made something scary to the PM who was in charge of it all? That is about the best I can come up with. I want to say the needed to index more than 191 chars, but that seems like a stupid thing to say. Who needs to index that many chars? If I remember, I'll edit :) edit: I guess I should say I was consulted to do some unrelated things, then helped them with some MySQL stuff that came up towards the end of the contract, then the utf8mb4 stuff came up, and I spent some time going through it with them. It was not the main focus of the contract, which is part of why I don't remember it very well. Just something that came up in the day to day...