So I am confused. So many posts on this, but I can’t find anything conclusive.
We have Norwegian language journals, hence a lot of non US characters in our database. When importing the database as an sql dump while trying to upgrade, phpMyadmin asks me to specify file charset. This is set to utf8.
In the sql dump I see references to utf8mb4 for charset and utf8mb4_general_ci for collation.
I can’t set charset to utf8mb4 in phpmyamin import, just utf8.
Then after importing most of the tables are latin1_swedish_ci (collation). Shouldn’t every table be the same ?
Should I import it as utf8 and then convert all table and table column collations to utf8mb4_unicode_ci?
Client and connection charset is set to utf8 in config.inc
Any other place I need to set encoding?