Textpattern CMS support forum

You are not logged in. Register | Login | Help

#11 2019-03-28 21:12:12

shayne
Member
From: Toronto
Registered: 2005-02-22
Posts: 34
Website

Re: Odd character encoding woes

I am running into a very similar issue, these ? characters appearing where quotes and apostrophes should be. Started about a month ago, the host did something, like an upgrade to services, just not sure what.

Running Textpattern 4.6.2. Coding is set to $txpcfg[‘dbcharset’] = ‘utf8mb4’; in config.php. I’ve tried adding AddDefaultCharset UTF-8 to .htaccess. I’ve got <meta charset=“utf-8” /> in the header of all pages. I’ve tried exporting, deleting, and importing the database.

I also took a back up of the site and installed locally, no issues.

Anything else I can be looking at?

Last edited by shayne (2019-03-28 21:15:54)

Offline

#12 2019-03-28 21:27:01

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 7,341
Website

Re: Odd character encoding woes

Hi shayne,

Did you consider updating the site to the latest txp version?


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | Respbublika! | NeMe @ github

Offline

#13 2019-03-28 21:33:42

shayne
Member
From: Toronto
Registered: 2005-02-22
Posts: 34
Website

Re: Odd character encoding woes

I think I want to resolve this issue before upgrading, but it is on the list.

Offline

#14 2019-03-28 22:04:57

shayne
Member
From: Toronto
Registered: 2005-02-22
Posts: 34
Website

Re: Odd character encoding woes

One more symptom to mention is that the articles that have the funny characters, also have blank body fields on the write screen. This is not that case in the local copy that I installed.

Offline

#15 2019-03-28 22:09:26

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 3,548
Website

Re: Odd character encoding woes

Can you do a detail diagnostics (Admin › Diagnostics › High diagnostics) and post the section with the database table entries? That tends to show you when the encoding of individual tables/columns differs from the encoding set in Textpattern or by the server.

However, I can’t remember if you get that much detail in the diagnostics with v4.6.2, though. If not, you can look at the individual tables in phpMyAdmin or another program to discern if some of the tables still use an older encoding.

You might also want to set $txpcfg['dbcharset'] = 'utf8'; and leave off the mb4 for now.


TXP Builders – finely-crafted code, design and txp

Offline

#16 2019-03-28 22:10:01

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 3,548
Website

Re: Odd character encoding woes

blank body fields

Ah, that came up somewhere else on the forum before…


TXP Builders – finely-crafted code, design and txp

Offline

#17 2019-03-29 10:00:08

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,207

Re: Odd character encoding woes

shayne wrote #317380:

also have blank body fields on the write screen.

jakob wrote #317382:

Ah, that came up somewhere else on the forum before…

E.g.
here (server update, TXP 4.5.7)
here (server migration, TXP 4.5.7)
here (10+ years old version, so server update very likely)


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#18 2019-03-29 12:23:05

shayne
Member
From: Toronto
Registered: 2005-02-22
Posts: 34
Website

Re: Odd character encoding woes

Hey folks this is resolved and here is how I did it…

Using phpMyAdmin -> Operations -> Collation for the database and the tables

Change each of the database table collation settings from Latin or other to utf8mb4_unicode_ci

Change each of the database collation settings from Latin or other to utf8mb4_unicode_ci

Export the database then drop all tables then import and problem solved…

Offline

Board footer

Powered by FluxBB