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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])