On Tue, 2016-01-26 at 11:06 +0000, Max wrote:
> 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.
Have you considered storing the text in its HTML equivalent?
So "maçã" becomes "apple" in Portuguese.
You'd have to convert your query parameters before running the select.
My tuppence worth.
HTH
Robert