|
|
|
|
|
|
by DCoder
3481 days 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? |
|
|
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...