Augusto Cesar Castoldi wrote:
> How can I configure postgreSQL to search without acents?
>
> Table “test”
>
> Clumns: name , values:
> Test
> Test
> tést
> Tést
>
Since those are actually different characters that only look the
same, you would have to use another approach:
select * from test where name like 't_st%';
or
select * from test where name like 'tést%' or name like 'test%' ...
--
jimoe at sohnen-moe dot com
