problems with signs of a mysql query with php

Question

 <div class="form-group">
        <label for="inputCNPJ">Atividade Primária</label>
        <br />
        <select name="id_cnae" class="browser-default custom-select">
                <option value=0>Atividade Primária</option>
                <?php                                
                        $sql = mysqli_query($conn, "SELECT id_cnae, descricao FROM CNAE") or die(mysqli_error($conn));
                        while($aux = mysqli_fetch_assoc($sql)) { 
                ?>
                <option value='<?php echo $aux["id_cnae"]?>'><?php echo $aux["descricao"] ?>
                </option>
                <?php
                        }
                ?>
        </select>
</div>

I’m having problems at the front, the result comes out with symbols instead of Ç and accentuation, my html already has UTF-8

Answer 1

Add <meta charset='utf-8'> at the header of your HTML file.

OR

Try to change your query for SELECT id_cnae, descricao FROM CNAE collate utf8_unicode_ci. But I suggest you change the collation (if that’s what you call it) of your tables on the bench.

Source: Another question from Sopt