Hi Augusto,
> How can I configure postgreSQL to search without acents?
> Is PostgreSQL have this support?
>
There isn't a specific function in postgresql. Maybe you could implement it in PL/Perl or any other PL/* language.
> SELECT * FROM test WHERE name LIKE _tes%_
>
> And it should return values _tést, test_
>
It's not a good idea to use _ to replace accents 'cause it would match undesirable expressions like tost, tist, tust,
txst,etc.
--
Euler Taveira de Oliveira
euler (at) ufgnet.ufg.br
Desenvolvedor Web e Administrador de Sistemas
UFGNet - Universidade Federal de Goiás
