utf8, spanish character and like statment

[Esteban Cabezudo]

I'm using 5.0 database version.

I have a database with character set utf8 and collation utf8_spanish_ci.
I have (at least two records whit name 'napoleon' and 'Napoleón'.
I want to do a

select id, name from table where name like '%aploleo%'

My result is one record. The 'naploeon' name.
If I use

select id, name from table where name like '%aploleó%'

My result is again one record. The 'Napoleón' name.

I I use

select id, name from table where name like '%aplole%'

I have two record.

I want the two record whit out distinction of o or ó.
My question is: ¿The character set and collation work here? I try with uft8 latin1 character set and utf8_spanish_ci and latin1_spanish_ci and utf8_general_ci and so but dont work.
Thanks.

PD: sorry by my English.