Field with Cedilla in Mysql

Question

I have a field in my database table Mysql with the name 'description', with the special accents.

My problem is this: When I make a INSERT INTO using directly the phpMyAdmin, it normally inserts the information into the table, but when using the mysql in the application it returns the following error.

This is my sql code:

INSERT INTO caixa_geral_dc (
descrição,
empresa,
valor_c_d,
conta,
categoria,
d_c,
usuario)
VALUES 
('GUARDA PROVISÓRIA DE VALORES',
'$nome_cliente[$i]',
'$v_recebido&[$i]',
'7',
'197',
'c',
'$_SERVER[nomeUsuario]')

I await answers.

Thank you

Answer 1

Enter the name of your field between ` to indicate that it is a field (this is also for restricted and/or spaced names)

INSERT INTO caixa_geral_dc ( `descrição`, empresa, valor_c_d, conta, categoria, d_c, usuario) VALUES ('GUARDA PROVISÓRIA DE VALORES', '$nome_cliente[$i]', '$v_recebido&[$i]', '7', '197', 'c', '$_SERVER[nomeUsuario]')

Answer 2

When you have a field with special characters or white spaces in it, this field should be declared within ``

Follows how your query should look:

INSERT INTO caixa_geral_dc ( `descrição`, empresa, valor_c_d, conta, categoria, d_c, usuario) VALUES ('GUARDA PROVISÓRIA DE VALORES', '$nome_cliente[$i]', '$v_recebido&[$i]', '7', '197', 'c', '$_SERVER[nomeUsuario]') 

Answer 3

Guys. Thanks for all your help, but I solved my problem. Just add the line

mysql_set_charset('utf8');

in the related.php file to work.

Recalling that also the addition of the crase before description, solved the problem.

Stayed like this:

Thank you very much! See you! D