[GENERAL] Case and accent insensitive

2016-01-26 Thread Max
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

Re: [GENERAL] Case and accent insensitive

2016-01-26 Thread rob stone
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

[GENERAL] Case Insensitive Accent Insensitive

2005-01-26 Thread icaro
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