Accent problems with PHP and Mysql

Question

I am making a PHP form, in which I used a javascript in a combo.

So when I select the first select, the second opens different data depending on what you select first. Until then ok, it works.

Example of two different options, which I used in dynamic combobox:

var groups=document.banquinho.oferta.options.length
var group=new Array(groups)
for (i=0; i<groups; i++)
group[i]=new Array()

group[0][0]=new Option("--")

group[1][0]=new Option("Erro na parametrização da regra de negocios")

group[2][0]=new Option("BA/SE - Pendência comercial")
group[2][1]=new Option("CO/N - Pendência comercial")
group[2][2]=new Option("CPF não confere com o nome do cliente")
group[2][3]=new Option("Data de nascimento digitada não confere com o CPF do      cliente")
group[2][4]=new Option("Documento não cadastrado no Serasa")
group[2][5]=new Option("Faixa etária não permitida para habilitação")

It works normal, but then when I go to enter in the database, I need to enter the code, equivalent to each offer of this combo.

Since I don’t know how to assign a numerical value to it directly in Javascript (maybe it’s even easier), I ended up doing a kind of trick to assign value in PHP.

$queryComp = "SELECT CodComplemento FROM test.tbl_complemento WHERE Complemento like '%$complemento%' ";
$resultComp = mysqli_query($link, $queryComp);
$numComp = mysqli_num_rows($resultComp);

if ($numComp > 0) 
{
    $dataComplemento    =   mysqli_fetch_array($resultComp);
    $varComplemento     =   $dataComplemento['CodComplemento'];
}
else 
{  
    $message  = 'Complemento não encontrado -> Invalid query: ' . mysql_error()  . "\n";
}

Where the Complement, is the value that is inside that matrix up there, as for example the value: "BA/SE - Trade pending".

There when I select in the combo, a sentence without accent, he finds it straight and assigned the value, but when it has accent does not work! I echo the query and the right accents appear and if I run it directly in the bank, it works.

The bank is in latin1_swedish_ci and the form in utf-8, I changed the table and the bank to utf-8 and nothing, for Latin again and nothing, I changed the form to "charset=ISO-8859-1" and nothing... I did everything that came to mind and I don’t know why it’s not rolling.

I went up the data in the table by means of that script, LOAD, which we called csv and it worked, the accents appear correctly. But when will I insert the word "no" by the form, for example, it is incorrect.

Can someone help me?

Answer 1

Try this and see if it solves the problem:

ALTER DATABASE `sua_base` CHARSET = UTF8 COLLATE = utf8_general_ci;