I am converting a few of my tables to utf8mb4 as well as the connection from PHP to MySQL to utf8mb4. This is so that I can support characters used for Emoji in my website.
I have two questions regarding this change:
1) Is it a problem having some tables as "utf8", even though the connection to MySQL now is "utf8mb4"? Can there be collation conflicts?
2) Do "utf8mb4" tables use more disk space, even if there is no utf8mb4 character stored on it?
3) Would you recommend me to change all the tables to utf8mb4?