Special chars in mysql query

[dstonek]

If a user search for a word like 'caño' he gets results containing both 'caño' and 'cano'.
I don't want to extend searches in words with 'n' instead of 'ñ'.
But I also want to keep such extension when a user is looking for a word with an ' á ' , results contain both ' a ' and ' á ' .
Thank you

[MarkR]

This is because of the collation set on the column (/table /database).

MySQL can set the collation on a per-column basis (although it's normally sensible to have it the same across your whole database).

Check the list of collations on the MySQL documentation, and apply one which does what you want.

Bear in mind that the collation is also affected by charset - so ensure that you're using the right encoding too.

Mark