Thread: accent-insensitive

Hello, I would suggest the inclusion an option to create the database 
accent-insensitive,
without need to use functions that in some cases it's slow to return the 
result.

Example:
select name from table where name ilike 'joão'

Return:
joão
joao
JOAO
JOÃO

Text by: Google translator

Regards,
Rafael

rgc.tech wrote:
> Hello, I would suggest the inclusion an option to create the
> database accent-insensitive,
> without need to use functions that in some cases it's slow to return
> the result.
> 
> Example:
> select name from table where name ilike 'joão'

Yes, this is in the current development branch (8.5) in contrib/unaccent.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support