The language support mode sets the default server character set for a user if the CREATE USER or MODIFY USER statement does not have a DEFAULT CHARACTER SET clause.
The DEFAULT CHARACTER SET clause overrides the language support mode for the user. You can also specify a server character set for a character column when you create the table.