Search engine accents issue

[argrafic]

Hello all.

In a site i'm developing in spanish I have a simple search engine, but I have a little problem.

I want the search engine to find words even if you write them with or without accent.

For example atún (tuna) has an accent, and right now it will only show results if i write atún, if I write atun it tells me there are no results.

My SQL statement is the following:
SELECT * FROM r_glosario WHERE titulo LIKE '%variable%%' ORDER BY titulo ASC

How can I make it that no matter if I write atún or atun I get the same results?

Thanks!

[dagon]

utf8, the table, the field, the query form the connection set everything to utf8

[Sxooter]

This is typically pretty db dependent.

In PostgreSQL you can use to_ascii to get this effect.

create table accenttest (i int, t text);
insert into accenttest values (1,'niño');
insert into accenttest values (1,'nino');
create index act_t_dx on accenttest (ascii(t)); -- optional, offers better performance
select * from accenttest where to_ascii(t) = to_ascii('niño');
 i |  t   

---+------
 1 | niño
 1 | nino
(2 rows)

There should be some functionally equivalent method in mysql, though you won't be able to index on it, likely.