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