Hi,
I had a problem with the names of categories, ezpages content, featured products content, manufacturers, not displaying correctly in UTF-8 in frontend. Having it solved successfully, I meant that the solution might interest somebody else, since I haven't found anything useful on the forum about it.
The problem was that the database tables, from which ZC reads data for categories, ezpage, featured products etc., were initially (i.e. at the moment of installation) encoded in a wrong character set. They were encoded in latin1_swedish_ci, instead of utf8_general_ci. In MySQL, it is called collation. So, basically, the problem was due to a database issue. I managed to correct it by converting the original collation to utf-8 in the following mode:
1. BACKUP YOUR ENTIRE DATABASE!!!!!
2. open phpMyAdmin in your cPanel
3. choose your ZC database and take a look at which tables (if not all) are in not utf-8 collation (encoding)
4. click SQL tab at the top of your phpMyAdmin screen and type the following text into the "Run SQL query/queries on database xxxxxx" field:
Run the query and that's it. You have changed the default collation for the chosen table. Check on your frontend, if special characters e.g. for your categories now display correctly in utf-8 encoding.Code:ALTER TABLE name of the table DEFAULT CHARACTER SET utf8
Bookmarks