I have a
VARCHAR(80) utf8mb4 column, and I'm testing adding some ASCII & Emoji characters, and use
CHAR_LENGTH() to understand the differences.
From reading in different places, my understanding is that each character on a
utf8mb4 column would take 4 bytes. However, it appears that it may not be the case, if I understand
LENGTH() as giving me the actual size that the specific contents are taking on that field.
Is it correct that a row with "aaaa" contents would take less storage than a row with "😁😁😁😁"?