accent-insensitive
Started by Ricardoover 16 years ago2 messageshackers
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
Re: accent-insensitive
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