Zen Follower
- Join Date:
- Mar 2005
- Posts:
- 166
- Plugin Contributions:
- 0
UTF8 and special characters after upgrade
Hello,
I have a UTF8 site set up. Everything was working fine until we upgraded to the latest version of Zen Cart. When doing that, all the special characters started showing strangely.
é is now é for example.
For a quick fix, I did a find and replace in the database to change these characters to their escape characters, but now "é" is showing in the plain text emails sent from the site.
Database collation is utf8_general_ci and products_name is "varbinary," while products_description is "blob."
To try to solve this, I added this file:
includes/extra_configures/my_db_charset.php - set to define('DB_CHARSET', 'utf8');
I also set the character set in zc_install when upgrading, as per a post I saw on the forums.
I also see this:
includes/functions/functions_general.php
Line #1513 : * convert supplied string to UTF-8, dropping any symbols which cannot be translated easily
Line #1518 : function charsetConvertWinToUtf8($string) {
Line #1520 : $string = htmlentities($string, ENT_QUOTES, 'UTF-8');
Line #1530 : if (CHARSET == 'UTF-8') return $string;
Line #1532 : $string = htmlentities($string, ENT_QUOTES, 'UTF-8');
What can I do to get these characters showing correctly? Thanks!
