How can I configure postgreSQL to search without acents? Is PostgreSQL have this support?
I configured my locale to pt_BR, that support acents, create table with enconding "latin1", but nothing works. I know that I can use function "TO_ASCII", and "select like "t_s%". Like: Table “test” Clumns: name , values: Test Test tést Tést SELECT * FROM test WHERE name LIKE “tes%” And it should return values “tést, test” Thanks, Augusto ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]