PHP not displaying some UTF-8 characters correctly

Question

PHP is retriving data from MySQL database. Now it's suppose to display the results to screen, but since my database contains characters like (ä,ö,ü,õ), which PHP displays (�,䄔). Database displays all characters correctly, so I don't think the problem is there.

I add following line to my code, that sets charset to UTF-8.

$conn->set_charset("utf8");

After adding that line, PHP displays following characters „”.

Also tried:

$conn->query("SET character_set_results=utf8");
$conn->query("SET NAMES 'utf8'");

How can I get PHP to display correct characters?

Here is the important part of my code

$conn = new mysqli($servername, $username, $password, $dbname);

$sql = "SELECT name FROM employee";
$stmt = $conn->prepare($sql);
$stmt->execute();

$stmt->bind_result($employee);
while($stmt->fetch()){
    echo "$employee|";
}
$stmt->close();
$conn->close();

I'm running on PHP 7 and MySQL 10.1.19-MariaDB.

Follow these examples including error output - do you get an error? php.net/manual/en/mysqli.set-charset.php — rybo111
– rybo111, Commented Apr 4, 2017 at 16:07
And have you done this w3schools.com/tags/att_meta_charset.asp — rybo111
– rybo111, Commented Apr 4, 2017 at 16:30

nithinTa · Accepted Answer · 2017-10-21 04:33:17Z

1

Consider the following things in this situations.

Make sure the header match the following

Content-Type:text/html; charset=UTF-8

and try setting UTF-8 in html

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

The source file encoding can make problems when string are hard coded in file. Since this file echoing it that seem to be no issue.

answered Oct 21, 2017 at 4:33

nithinTa

1,6402 gold badges18 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

am05mhz Over a year ago

you can also call header('Content-Type: text/html; charset=UTF-8'); at the very beginning or your code

Tambet-Telvis Tanilsoo Over a year ago

I did try that solution at that time, but found out that problem was in java client side program. Anyway still good solution, maybe it'll help someone.

Collectives™ on Stack Overflow

PHP not displaying some UTF-8 characters correctly

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related