Changing collation of database tables?
Some characters of product names and discriptions will not be correctly displayed on my pages, like ü, ö, ä etc. I guess this has to do with the collation used in the database.
(Because on other parts of my pages this characters display correctly!)
I tried to change the collation to utf-8 but can't find how to change the collation of a whole table. ? (The collation of the tables seems to be still in "latin1_swedish_ci".)
I changed the collation in every column of the products table to utf-8 but that didn't solved the issue.
I have attached two screenshots for better understanding.
Could someone please give me a hint how to change the collation of the whole tables ?
If that would solve the issue ... Or any other suggestions ?
Thanks a lot!!
I use:
phpMyAdmin - 2.11.9.6
MySQL-Client-Version: 5.0.88