Post's tags do not support accented characters

[Cimmo]

WordPress 4.3

Steps:

• create a post
• add a tag that contains accented letter like 'ü'
• save

Result:

• tags do not support utf-8 correctly? accented letter is corrupted

Expected result:

• tags correctly support utf-8 and accented letters

[SergeyBiryukov]

Hi @Cimmo, thanks for the report.

I could not reproduce the issue, the tag is displayed correctly after saving: 33731.png​.

What is the database collation on your install?

[Cimmo]

You are right, just that letter works, try this tag 'Üürikomisjoni' and save the post.
Anyway:

All tables are:
Database: MyISAM
Collection: utf8mb4_unicode_ci

Database was defaulted to latin1_swedish_ci not sure why, I changed it now to utf8mb4_unicode_ci and the problem persists.

[SergeyBiryukov]

"Üürikomisjoni" works too: 33731.2.png​.

Does the issue still happen with all plugins disabled and a default theme (Twenty Fifteen or Twenty Fourteen) activated?

[Cimmo]

This is with twenty fourteen theme and deactivated all plugins. Still reproduces.
To be mentioned that in the post itself the problem does not reproduce, only on tags.

[Cimmo]

Tags after post has been saved.

[swissspidy]

Replying to Cimmo:

All tables are:
Database: MyISAM
Collection: utf8mb4_unicode_ci

Database was defaulted to latin1_swedish_ci not sure why, I changed it now to utf8mb4_unicode_ci and the problem persists.

Really sounds like something's off with the database config.
What about the collation of the name field in the wp_terms table? This should be utf8mb4_unicode_ci too. Which version of MySQL are you using?

[swissspidy]

#33864 was marked as a duplicate.

[mehulkaklotar]

The category szél should be added but it is denying the because of the category szel.

[mehulkaklotar]

check at sql level BINARY will let the cateogry szél be added even if the category szel category is added

[SergeyBiryukov]

@mehulkaklotar, could you move the patch over to #33864?

This ticket seems to be unrelated and looks more like a configuration issue (broken encoding for AJAX requests).

[Cimmo]

Replying to swissspidy:

Really sounds like something's off with the database config.
What about the collation of the name field in the wp_terms table? This should be utf8mb4_unicode_ci too. Which version of MySQL are you using?

'name' has utf8mb4_unicode_ci collation
MySQL 5.5.44

Anything wrong with it?

[mehulkaklotar]

Moving the patch to the #33864.

[SergeyBiryukov]

Replying to Cimmo:

'name' has utf8mb4_unicode_ci collation
MySQL 5.5.44

Anything wrong with it?

Nope. Could you try adding AddDefaultCharset utf-8 at the top of your .htaccess file and see if that helps?

[swissspidy]

@Cimmo Is this still an issue on your site? Have you tried updating the .htaccess file like suggested above?

[boonebgorges]

As it appears that this problem is due to a charset configuration issue, and since the ticket hasn't been confirmed since the last update several years ago, I believe the ticket is safe to close.