Encoding errors after site migration

This support ticket is created 6 years, 6 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	-	-
13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	-	-

Supporter timezone: America/New_York (GMT-04:00)

Tagged: Types plugin

This topic contains 1 reply, has 2 voices.

Last updated by Christian Cox 6 years, 6 months ago.

Assisted by: Christian Cox.

Author

Posts

July 24, 2018 at 5:40 pm #954628

MorganM3180

I am trying to: correct an encoding error

Link to a page where the issue can be seen:
academyofyachting.org/faq

I expected to see:
normal text

Instead, I got:
as â€œCommodoreâ€ or â€œPast Commodoreâ€ or just plain old â€œMisterâ€ or â€œMs.â€?

I can perform the mysql query to repair, but I need to know which table to query.
I'm not sure where this is in the database-please provide me the name of the table in the database.

July 24, 2018 at 7:58 pm #954678

Christian Cox

It depends on what kind of information this is, and I can't determine based on your description. Is it part of a post's content? Part of a Layout or Content Template's content? Those things would be in the posts table (wp_posts by default, unless your site uses a custom table prefix).

Is it in a Post custom field? That information is in the postmeta table.
Is it in a User custom field? That information is in the usermeta table.
Is it in a Term custom field? That information is in the termmeta table.

Is it part of the main site information, like the tagline or title? That information is in the options table.

Is it part of a translation? It could be in a WPML table.