SQL query returns

Asked

Viewed 71 times

1

I have a table for the query to send the information there, and it appears " " instead of letters with accents. I am already using html <meta charset="UTF-8"> Is there something missing? This is the first time this has happened to me.

  • 5

    The answer to this question should help you Doubt with charset=iso-8859-1 and utf8

  • In this post tells me to always record without BOM, I record and no problem, the data is inserted with all the accents correctly, the problem is that if I do not insert with PHP, and insert somento in phpmyadmin, when I try to see the data by PHP comes these characters.

  • In this post that Linkei (http://answall.com/a/43205/3635) speaks much more than BOM, talks about everything, from how to connect, how to save and how to set the header ;)

1 answer

2


In your database connection, you need to set the charset.

$link = mysql_connect('localhost', 'user', 'password');
mysql_set_charset('utf8',$link);

And also make sure your base is at utf-8

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

Browser other questions tagged

You are not signed in. Login or sign up in order to post.