The apostrophes are not displayed when getting data from MySQL into bootstrap table

Question

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:

<?php
  include_once 'include/connect_db.php';

  $query = "SELECT * FROM myTable;";
  $result = ejecutar_query($query);

  $list = array();
  while ($b = mysqli_fetch_array($result)) {
    $list[] = $b;
  }
?>

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

<!--jQuery Datatable-->
<script>
     $(document).ready(function(){
              $('#myTable').dataTable({
              "sPaginationType":"full_numbers",
              "aaSorting":[[0, "asc"]],
              "bJQueryUI":true
              });

              hideLoading();

     });
</script>

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

does the select query work if you use it directly on the db? — Umashankar Das, Jun 03 '17 at 12:31
Just use Markus Zeller's answer. It should work fine. ideally. — Umashankar Das, Jun 03 '17 at 12:38

score 2 · Accepted Answer · answered Jun 03 '17 at 12:34

2

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

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

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

answered Jun 03 '17 at 12:34

Markus Zeller

8,516
2
29
35

This would be the correct answer, But, it is important to confirm if , the data is stored in the db properly. Otherwise, none of the above would work. – Umashankar Das Jun 03 '17 at 12:36
To make it more properly you could even wrap it like that: ``. It just depends on the data. – Markus Zeller Jun 03 '17 at 12:44

score 0 · Answer 2 · answered Jun 04 '17 at 06:58

0

Do not use any encode/decode functions; that just compounds the problem.

See here for discussion of the causes and cures of "black diamond".

answered Jun 04 '17 at 06:58

Rick James

135,179
13
127
222

The apostrophes are not displayed when getting data from MySQL into bootstrap table

2 Answers2