0

I'm storing strings in a mysql database, with utf8_general_ci.

I have accented characters, for example in phpmyadmin I have É that will become É with a simple mysql select and php print.

But on my new server, after I copied all files and restored a dump with mysql -p < dump.sql, that stays É when displayed on the page.

Other strings on the page are displayed normaly, only those comming from mysql have the problem. But I don't understand the cause as the files and database are the same that on my old server.

Cid
  • 14,968
  • 4
  • 30
  • 45
Entretoize
  • 2,124
  • 3
  • 23
  • 44
  • 1
    Note that the english for *bdd* (from the french *base de données*) is *db* (database) – Cid Jan 22 '20 at 15:23
  • @Cid sorry didn't think – Entretoize Jan 22 '20 at 15:35
  • See "Mojibake" in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored – Rick James Jan 23 '20 at 07:07
  • If you want to discuss further, provide information such as: Connection parameters, `SHOW CREATE TABLE`, HEX() of the column (to check for "double encoding", `` if using HTML, etc. – Rick James Jan 23 '20 at 07:11
  • Nobody wants to understand the the db is not in cause has this is the copy of a working db using the exact same php script. I checked the hex and there are the same on both. – Entretoize Jan 23 '20 at 08:34

0 Answers0