ljbomir

Hi

–I’ve added these manually in wp-config.

define( ‘DB_CHARSET’, ‘utf8’ );
define(‘DB_COLLATE’, ‘utf8_general_ci’);

Without much result.

–I’ve verified the charset of exported db dump:

CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=44

Then I dropped and recreated the database with these exact encodings just to match with the source.

— Verified php configuration is set to UTF8

$grep ^default_charset $(locate php.ini)
/etc/php/7.0/apache2/php.ini:default_charset = “UTF-8”
/etc/php/7.0/cli/php.ini:default_charset = “UTF-8”
/etc/php5/apache2/php.ini:default_charset = “UTF-8”
/etc/php5/apache2filter/php.ini:default_charset = “UTF-8”
/etc/php5/cli/php.ini:default_charset = “UTF-8”
/etc/php5/fpm/php.ini:default_charset = “UTF-8”
/usr/lib/php/7.0/php.ini-development:default_charset = “UTF-8”
/usr/lib/php/7.0/php.ini-production:default_charset = “UTF-8”
/usr/lib/php/7.0/php.ini-production.cli:default_charset = “UTF-8”

—Tried forcing “AddDefaultCharset UTF-8” in /etc/apache2/conf-enabled/charset.conf

—Added
header(‘Content-type: text/html; charset=UTF8’);
in
/wp-content/themes/lychee/header.php

Still the same issue.

I am starting to suspect there must be something within the php files inside the wordpress directory, which is setting it to iso-8859-1

Thanks,
Lyubo

Thank you for your reply.

It was set to latin1 (8859-1).

MariaDB [(none)]> SHOW CREATE DATABASE urbana_bg;
+———–+———————————————————————-+
| Database | Create Database |
+———–+———————————————————————-+
| urbana_bg | CREATE DATABASE urbana_bg /*!40100 DEFAULT CHARACTER SET latin1 */ |
+———–+———————————————————————-+
1 row in set (0.00 sec)

Then I changed it to UTF8.

MariaDB [(none)]> alter database urbana_bg collate=’utf8_general_ci’;
Query OK, 1 row affected (0.00 sec)

Then verified it is applied.

MariaDB [(none)]> SHOW CREATE DATABASE urbana_bg;
+———–+——————————————————————–+
| Database | Create Database |
+———–+——————————————————————–+
| urbana_bg | CREATE DATABASE urbana_bg /*!40100 DEFAULT CHARACTER SET utf8 */ |
+———–+——————————————————————–+
1 row in set (0.00 sec)

But the links are still crashing and I still get the 8859-1 charset in the header response.

text/html; charset=iso-8859-1

Source site:

Request Headers:
Accept-Language: en-us

Response Headers:
Content-Type: text/html; charset=UTF-8

Destination site:

Request Headers:
Accept-Language: en-us

Response Headers:
Content-Type: text/html; charset=iso-8859-1

It seems like charset has been changed from UTF-8 to iso-8859-1 after moving the site. This is reported in response headers.

• This reply was modified 8 years, 6 months ago by ljbomir.

I’ve just tried adding “AddDefaultCharset off” in apache configuration for this specific vhost, but without much difference.

Lyubo