One would be: Never use "utf8" character set, only "utf8mb4". "utf8" is limited to those characters that only use four bytes, and everything else will be trunca

One would be: Never use "utf8" character set, only "utf8mb4". "utf8" is limited to those characters that only use four bytes, and everything else will be truncated. "utf8mb4" is what you want when you think about UTF-8.