Let’s say if I’m making a website where I let people using emojis in their username, and I will have a table for each user to store their info/profiles/etc.., and the name of will be the same as their username.
I have no problem storing emojis or any special character into a table as data.
The character set and collation are both set utf8mb4 for my database, and I also have “CHARSET=utf8mb4” statement in my php mysqli_query function when I create the tables, it worked perfect for all kind of symbols, Chinese Characters, Japanese characters, even when I try to have these special character as part of the table names, no problem.
However, when I try to have emojis as part of the table names, whether I rename or create a table, mysql gives me a “#1300 – Invalid utf8mb4 character string” error.
Is it not possible to have emoji in the table names? If it is possible, how to do it?