Matching db values with special chars

Question

Is there a way to match values in query if the stored data has special characters, and the search query doesn't:

For example: I want to match a column with the following value:

Doña Ana

but I can only search using

Dona Ana 

Answer 1

You may collate the column of interest to Latin general, which doesn't have accents:

SELECT *
FROM yourTable
WHERE name COLLATE latin1_general_ci = 'Dona Ana';