Collation for international characters (Spanish), php

Question

I have ñ's and á's in the cells of my database. My collation is set to utf8, but on the website my characters are not displaying right.

Esperamos que disfrute del programa y aprenda bastantes consejos 
�tiles para padres para mejorar el desarrollo de su hijo. Tambi�n 
puede aprender de otras mam�s y ellas de usted. El Foro...

Displaying it via SELECT statement and then through php on the page. Let me know if you need more information. Perhaps this is a common problem?

Post your code. Looks like character sets are not getting translated properly between entry, DB write, DB read, and display. — miken32, Feb 18 '14 at 21:30
use headers header('Content-Type: text/html; charset=utf-8'); — Dvid Silva, Feb 18 '14 at 23:02

score 1 · Answer 1 · edited May 23 '17 at 10:26

1

Try with this header at the top of your php script:

header('Content-Type: text/html; charset=utf-8');

and/or the META tag as a linked answer says.

<meta charset="utf-8">

edited May 23 '17 at 10:26

Community

1
1

answered Feb 18 '14 at 21:32

Luigi Siri

2,068
2
19
27

I did both things, then I finally got it working with mysqli_set_charset() – broinjc Feb 19 '14 at 00:03

broinjc · Answer 2 · 2014-02-19T21:38:35.673

1

After checking that my charset was correct, this did the trick.

class DBMySQL{
// ...
    private function set_connection($connection) {
        $this->_connection = $connection;
        mysqli_set_charset($connection, "utf8"); // VICTORY!
    }
// ...
}

edited Feb 19 '14 at 21:38

answered Feb 19 '14 at 00:02

broinjc

2,619
4
28
44

Collation for international characters (Spanish), php

2 Answers2