I have run into this same problem on an application I am working on but we are putting it off but will more then likely just remove the accent before entering it into the database because mssql full text search doesnt see them as the same thing, and thats whats being used.
That is due to folding and mapping of characters to a common derivative - which is normally a English-Latin characters (non-accented Latin) due to the dominance of English in programming implementations.
It normally makes sense to add folding, Google for example employ the technique also.
There might be a config option in MSSQL, but in MySQL it's an in-built feature.
For non-FT queries you can do a binary compare:
SELECT * FROM myTable WHERE BINARY title = 'Confederación';