0

I have a problem with the characters displayed in a webpage when picked up from a database.

Storage Engine: MyISAM

Collation: latin1_swedish_ci

In the databes the strings are stored correctly like in the following screen: Data stored correctly

But when they are displayed on the web page i get that "?" strange characters instead of the "è" that should be displayed. Like in this example:

Problem

I tried many different collations but i can't find a way to solve this problem. I hope it's something easy to solve. Thank you very much.

Alexandru Duma
  • 21
  • 1
  • Do you have this in your HTML head? `` – rybo111 May 27 '17 at 17:35
  • I didn't. I added in my code but it did not solve my problem – Alexandru Duma May 27 '17 at 17:49
  • try this ` ` – Ravi Chaudhary May 27 '17 at 18:21
  • We can't really tell if it is stored correctly without seeing `HEX(col)`. – Rick James May 27 '17 at 20:15
  • Question Marks (regular ones, not black diamonds) (Se?or for Señor): The bytes to be stored are not encoded as utf8/utf8mb4. Fix this. The column in the database is CHARACTER SET utf8 (or utf8mb4). Fix this. Also, check that the connection during reading is UTF-8. -- see https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored – Rick James May 27 '17 at 20:16

0 Answers0