Textpattern CMS

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

jakob

Admin

From: Germany

Registered: 2005-01-20

Posts: 5,239

Website GitHub

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

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

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,319

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}

#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…