Re: Query for retrieving all rows containing é

[Ernesto Pareja]

Hello,

I had the same problem and I think I read all the forums arround this topic.
I'm using Mysql for Windows 5.1.45 and apache for webserver with PHP 5 interpreter

I had the same problem described here and I changed the Database Schema Collation to latin1-latin1_spanish_ci.

In the HTML files I changed the charset metatag to iso-8859-1. This is Western European.

I also had to place in the inserts of the SQL scripts on my PHP the html_entity_decode($variable) and when showing the variables in the echo directive I had to encode the varaible again "echo htmentities($variable);"

Hope this helps someone.

Ernesto Pareja