Some space showing � in the html page

Question

In a html page, some space showing �. I am also using

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

in the head, but not working. Here is an example:

Movie: Bombay Velvet
Singer:�Suman Sridhar
Music:�Mikey McCleary
Music Label: Fox Music

I am trying to figure out from yesterday, but couldn't. Please help, what might be causing this issue.

Solved: mysql_query("SET NAMES 'utf8'", $connect);

Thanks to everyone.

Check encoding (utf-8) and filter and/or sanitize what is causing the output. — Nitin, Jun 16 '17 at 13:56
try to open your file on notepad > save as > change the encoding to UTF > save (overwrite) and se if it works =] — Elmer Dantas, Jun 16 '17 at 13:57
Actually it is a php page, trying to pull all content from mysql saved in utf8mb4_unicode_ci. — Dilip Kumar, Jun 16 '17 at 14:00
I also tried saving the file in UTF in notepad and reupload. But not working — Dilip Kumar, Jun 16 '17 at 14:09
Possible duplicate of [UTF-8 all the way through](https://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — Martin, Jun 16 '17 at 14:10
@DilipKumar read the answers on the post linked above, that **will** solve your issue. — Martin, Jun 16 '17 at 14:10

score 0 · Answer 1 · answered Jun 16 '17 at 14:08

0

As your data comes from a Database and PHP. You can set connection enconding at startup.

If you are using Mysqli connection driver you can do this:

mysqli_set_charset ( $mysql_connection , 'utf8' );

or in OOP:

$mysql_connection->set_charset('utf8');

In another drivers you need to see similar function.

answered Jun 16 '17 at 14:08

Fábio Arantes

Sorry not working yet. May be some other problem here. I will go for the link provided by Martin – Dilip Kumar Jun 16 '17 at 14:13
Charset problems is very anoing. You need to verify these things: - if your connection to database are responding in correct charset. - if your files are saved in correct enconding (in Atom, this is showed at bottom bar) - if your http request in on correct encoding (this can be changed at runtime using: `header('Content-type: text/html; charset=utf-8');` – Fábio Arantes Jun 16 '17 at 14:19
yeah i tried checking it from the server side and yeah it is saved in UTF. And also i tried header in php, not working yet. – Dilip Kumar Jun 16 '17 at 14:38

1 Answers1