E.g. when I enter 'Крилл' in the name, meta_description or description fields on the product edit page, they always end up as '?????' in the MySQL database.
Suggested bugfix: Make sure Opencart uses a proper UTF-8 connection.
Update file /system/database/mysql.php as follows in the constructor method:
Code: Select all
public function __construct($hostname, $username, $password, $database) {
if (!$this->connection = mysql_connect($hostname, $username, $password)) {
exit('Error: Could not make a database connection using ' . $username . '@' . $hostname);
}
if (!mysql_select_db($database, $this->connection)) {
exit('Error: Could not connect to database ' . $database);
}
mysql_query("SET NAMES 'utf8'", $this->connection);
mysql_query("SET CHARACTER SET utf8", $this->connection);
mysql_query("SET character_set_connection=utf8;", $this->connection);
}