[RESOLVED] PHP returns no results whenever an extended character (e.g. ó or ú) is used

[steveryan]

Hi all

I hope someone can help me with this as I am finding it very confusing.

I have a search form which works fine when I use normal English characters. However when I use Spanish characters no results are ever returned.

For example, let's say I want to search for "Selección".

The SQL I generate in PHP will look like this:

select * from table where (title like '%Selección%')

If I run this SQL directly on the MySQL database it will return 1 result.

However if I run it within PHP it will return no results.

This is my code:

$query = "select * from table where (title like '%Selección%')";
$result = mysql_query($query);

As you can see, it's very simple.

Do any of you have any ideas what could be causing this?

Thanks!

[steveryan]

Fixed it.

htmlentities - which I use to sanatise user input - was converting the extended characters into different characters...

[dagon]

glad you fixed it, jjust some thoughts\notes

with accents you want to make sure everything uses the same charset, web page, db and db connection. utf8 is a good idea, i wish it was the default for everything, issues with mixed languages appear here often.