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]
