Can mysql charset for table and column be different?

Question

Does it makes sense to have two different charset for table and a single column in the same table ? or will it create problem, especially for the below mentioned example ?

For example,

Table charset - latin1
Column C1 charset - utf8mb4

Answer 1

Tables don't have a charset anyway, the only thing they have is a default charset. The only thing that has an actual "physical" charset are columns, because they're the only thing that actually stores data. The way it works is that if you're not setting an explicit charset for a column, the table's default is used. And if the table doesn't have a default, the database's default is used. And if that doesn't have a default, the server's default is used.