Is there a collation for case and accent insensitive filter? I just found the use of operators like ILIKE ou CITEXT module but I can't use ILIKE in the queries and the CITEXT is a field-by-field solution for the case insensitive part of the problem. I also found the unaccent text search dictionary that could help with the accent part.
In the MySQL world we have the database level collation latin1_swedish_ci where 'maca' = 'Maçã' is true and no field level configuration is required.
This database is hosted in Amazon Cloud so I'm also limited by what I can do in this environment.