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
On Tue, 2016-01-26 at 11:06 +, 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
Hello,
We have an application we want
to migrate to PostGreSQL. Our application uses a lot of
queries comparing strings with Like and =. It is an
application for libraries and we need to do
the comparisons in a case insensitive and accent
insensitive way.
We are trying to save time. We