ñ character showed as �, when retrieving from mysql to php

Question

I have a data in my mysql database's table which is Biñan. However, when I try to retrieve it using php, it showed as Bi�an in my dropdown list.

Here is my sample code:

<?php
   $query = "SELECT * from municipality";
   $res = mysqli_query($conn,$query);
   while($row = mysqli_fetch_assoc($res))
   {
     echo "<option value='".$row['m_id']."'>".$row['m_name']."</option>";
   }
?>

But when I manually echo/insert the character ñ in php/mysql it displayed as is. I have also set the charset to UTF-8.

PROBLEM SOLVED!: I just have to replace the ñ with Ã± in my database's table. So it shows ñ in my website.

**NO!** Two wrongs do not make a right! Don't "replace the `ñ` with `Ã±`"! See "black diamond" in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored for the likely cause(s) of such. That should help you solve it completely, not one case at a time! — Rick James, Aug 20 '18 at 04:13

score 0 · Answer 1 · answered Aug 12 '18 at 00:39

0

add this in your head html file.

in a balise:

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

answered Aug 12 '18 at 00:39

Berthol Yvano

306
3
8

I followed your instruction, but the output was still the same.. – ravendee Aug 12 '18 at 00:48

score 0 · Answer 2 · answered Aug 12 '18 at 00:42

0

Try to:

ALTER DATABASE <databasename> CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE municipality CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

answered Aug 12 '18 at 00:42

zen

980
6
18

score 0 · Answer 3 · answered Aug 12 '18 at 00:59

0

otherwise it's in the database. do this in your database.

ALTER TABLE municipality COLLATE utf8_general_ci

or

ALTER TABLE municipality CONVERT TO CHARACTER SET utf8;

answered Aug 12 '18 at 00:59

Berthol Yvano

306
3
8

ñ character showed as �, when retrieving from mysql to php

3 Answers3