-1

We are working on a website and my boss transferred the site form one host to a different one. With this transfer came the problem, the character set has changed on the server so all our word and symbols like " ë " and " Ê " and even " ' " normal reading symbols have changed to this geëet and this Rosè.

We have tried doing the comment out " //define('DB_CHARSET', 'utf8'); //define('DB_COLLATE', ''); " but then the whole site breaks down ... Does anybody have a solution?

danblack
  • 12,130
  • 2
  • 22
  • 41
WernerB
  • 1
  • 2
    Show the code. How did the migration occur? From what database version? To what database version? Show the table defination (`SHOW CREATE TABLE tblname`) for the tables containing the broken character sets? – danblack Feb 27 '19 at 12:41

1 Answers1

0

geëet Rosè is Mojibake for geëet Rosè

You probably have latin1 somewhere in the processing.

Search for Mojibake in this Q&A: Trouble with UTF-8 characters; what I see is not what I stored

The data can probably be repaired, but we need a lot more info to avoid making things worse!

SHOW CREATE TABLE
SELECT col, HEX(col), LENGTH(col), CHAR_LENGTH(col) FROM ...  -- for a simple example

Also, check the WP configs. How was the "transfer" performed; give details.

Rick James
  • 135,179
  • 13
  • 127
  • 222