3 ms·
What we can judge harshly is that it accepted the 4-byte sequences and failed silently, corrupting data. A sane system would reject the 4-byte sequences so you
by chmod600 5y ago
What we can judge harshly is that it accepted the 4-byte sequences and failed silently, corrupting data.
A sane system would reject the 4-byte sequences so you could try again without the emojis.
But if users got errors, they might investigate, and it would slow down the rapid growth mysql was aiming for. So they just decided not to throw errors.
- petee 5y agoI agree, although the change was prior to 4-byte utf (2002 vs 2003) the same issue would have manifested with 6 byte sequences. Very curious. It would be really interesting to see a postmortem by mysql if ever possible, because the more I think about, 3 is such an odd choice (pun), and people usually do most things for a reason haha, its either lost to time, or a brainfart off-by-one.