Re: [GENERAL] Seaching without accents

[James M Moe]

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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html