Re: What is the best practice to store utf8 and us-ascii ?

[Alexander Barkov]

Eric,

right, you can use utf8 as the default character set and
declare some columns using latin1.
You can do visa versa. Everything depends on amount of
utf8 and latin1 columns.

Also, you can use utf8 with VARCHAR for everything.
As VARCHAR is a variable-width data type, it does not
waste unnecessary space, like CHAR does.