Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Odd character encoding woes
I think I want to resolve this issue before upgrading, but it is on the list.
Offline
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
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
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,304
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
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