Unicode characters properly pulled from MySQL [PHP MYSQL]

Question

I am fetching the image filepath from my MySQL database, and everything worked fine until the name of the path has some unicode characters associated to it. For example, I am using this code to fetch the image filepath;

$sql = "SELECT images FROM agents";
$basePath = "http://localhost/img/";
$result = mysqli_query($con, $sql);
while ($row = mysqli_fetch_array($result)) {
    $img = $row['images'];
    $actualPath = $basePath . $img;
    echo $actualPath;
}

For English alphabet pictures, it's okay, it turned out something like http://localhost/img/selena.jpg but if it's using unicode characters, it will be like http://localhost/img/11_??.jpg whereas the true filepath would be http://localhost/img/11_副本.jpg
How do I make that 副本 characters stay after it is pulled from MySQL rather than just becoming ?? symbol ?

EDIT: I used a prepared statement method, not the basic mysqli_query() command.

You have to check the character set in PHP and mysql and the file saved name. — Naga
– Naga, Commented Dec 23, 2016 at 6:50
@AfiqIzzat try $actualPath = $basePath . htmlentities($img, ENT_COMPAT, 'UTF-8'); — Beginner
– Beginner, Commented Dec 23, 2016 at 8:54
@Beginner, the result still remains the same, it outputs å¯æ¬ instead of 副本 — Afiq Izzat
– Afiq Izzat, Commented Dec 23, 2016 at 8:59

Samir Selia · Accepted Answer · 2016-12-23 06:51:19Z

1

Use SET NAMES UTF8 before your query to handle Unicode characters.

mysqli_query($con, 'SET NAMES UTF8');

$sql = "SELECT images FROM agents";
$basePath = "http://localhost/img/";
$result = mysqli_query($con, $sql);
while ($row = mysqli_fetch_array($result)) {
   $img = $row['images'];
   $actualPath = $basePath . $img;
   echo $actualPath;
}

answered Dec 23, 2016 at 6:51

Samir Selia

7,1502 gold badges14 silver badges33 bronze badges

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

6 Comments

Afiq Izzat Over a year ago

Does it work the same if I used prepared statement ?

Afiq Izzat Over a year ago

Now, it becomes http://localhost/img/11_å¯æ¬.jpg, I still want it to become 副本

Samir Selia Over a year ago

Can you post how this image link is stored in the DB?

Afiq Izzat Over a year ago

I stored only the filepath of the image and call it on another server for the picture by just relaying the filepath (basepath + imgpath). The filename is 11_副本.jpg.

Samir Selia Over a year ago

when you query through terminal or any tool, does your image value in the DB look exactly like 11_副本.jpg ?

|

Collectives™ on Stack Overflow

Unicode characters properly pulled from MySQL [PHP MYSQL]

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related