Hi, I am having a problem with international characters. I have an ajax autocompleter executing to help me fill a list from a 10,000 row table in the database. When I use non-scandic characters everything is fine but as soon as I enter a special character then my query does not return anything in the controller even though the same query from the development.log returns data when executed in the database.

I have the following line in my controller: $this->Words = $this->Word->findAll("word like '" . $this->params['wordpart'] . "%'");

which generates a query like this: SELECT * FROM words WHERE word like 'päi%'

I am using MySQL and in the query log I see the same exact query: SELECT * FROM words WHERE word like 'päi%'

Executing this in Query Browser returns rows, but I do not get anything back to my application.

My DB character set is Latin1 and my form charset="iso-8859-1".

Where am I going wrong?

Thanks in advance.