Characters with accents and diacritics showing incorrect - MySQL

Question

Characters with accents and diacritics showing incorrect - MySQL

Some characters with accents and diacritics, that are loaded from MySQL database are not showing correctly on the website. I am using UTF-8 encoding in the meta tag. Could you please tell me what is wrong and how to fix it ?

0

Report

24 Mar 2020 at 06:11 PM

Stor

accent

diacritic

mysql

php

2 answers

OK

Tim · Answer 1

Hi,

You have to check if the characters with accents are correctly inserted in MySQL table. If they are showing correctly in MySQL database, then you can try to include mysql_set_charset() or mysqli_set_charset() function in the souce code.

Stor · Answer 2

I found that incorrectly showing characters are included in MySQL table. What should I do in this case ?

Characters with accents and diacritics showing incorrect - MySQL

accent

diacritic

mysql

php

Incorrect integer value '' for column 'user_id' at row 1 - error

Fatal error: Call to undefined function mysql_query() - PHP

Send email with CC copy and BCC hidden recipients - PHP

Get date of tomorrow, day after, yesterday, day before - PHP

How to remove / replace multiple <br /> line breaks in PHP ?

Examples of difference between == and === , != and !== in PHP

Fix warning: Headers already sent - setcookie error in PHP