I don't know what else to do.. any hints appreciated.
I amb building a website that needs to accept all western characters. I read that UTF-8 is the way to go. And this is what I have:
In the html:
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
In the PHP (called using AJAX, don't know if this is important):
header('Content-Type: text/plain; charset=UTF-8');
In MySQL:
Database: CHARACTER SET utf8 COLLATE utf8_general_ci;
Table: CHARACTER SET utf8 COLLATE utf8_general_ci;
Row: Collation utf8_general_ci
MySQL connection collation: utf8_general_ci (I see this in first page of phpMyAdmin)
Still, some special characters, like the spanish Ñ, that I insert in the database through the website, from user input, are not stored correctly. I have no idea what I'm missing...