After spending almost all of my day searching a fix to this I come to you guys.
I need to do an accent insensitive word search on my db(InnoDB), but I cannot get it to work.
t1 table, the field
description which is an indexed
varchar(250), furthermore my table collation is
t1 have a record in which the field
description have stored
bla bla... instrucción... bla. just in case you are wondering how are the records stored.
I'm trying to fetch the records using the words
instruccion using this:
SELECT id FROM t1 WHERE description LIKE '%instruccion%'
If I use
instrucción I get a non-empty result, but using
instruccion I get an empty result.
Please help and thanks.