mysql 出现撇号 >,从MySQL将数据获取到引导表时不显示撇号

When I execute SELECT query in php in order to get data from MySQL DB into bootstrap table, the apostrophes are not displayed correctly in the table rows. In particular, I get Gr�a instead of Grúa.

This is how I get data from MySQL DB:

include_once 'include/connect_db.php';

$query = "SELECT * FROM myTable;";

$result = ejecutar_query($query);

$list = array();

while ($b = mysqli_fetch_array($result)) {

$list[] = $b;

}

?>

<?php echo $row['name'];?>

$(document).ready(function(){

$('#myTable').dataTable({

"sPaginationType":"full_numbers",

"aaSorting":[[0, "asc"]],

"bJQueryUI":true

});

hideLoading();

});

Should I change the encoding in MySQL DB or what should I do to solve this issue?

解决方案

You need to encode/decode the chars in that case. Changing the charset of the table/database may cause data loss.

<?php echo utf8_encode($row['name']);?>

if utf8_encode() does not work try utf8_decode() instead.