Seaching without accents - Mailing list pgsql-general

From Augusto Cesar Castoldi
Subject Seaching without accents
Date
Msg-id 20040128124100.CE6F219F7@mail.npd.ufsc.br
Whole thread Raw
Responses Re: Seaching without accents  (James M Moe <jimoe@sohnen-moe.com>)
Re: Seaching without accents  (Marco Lazzeri <marcomail@noze.it>)
Re: Seaching without accents  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-general

How can I configure postgreSQL to search without acents?

 

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

pgsql-general by date:

Previous
From: MaRCeLO PeReiRA
Date:
Subject: Re: Logging all queries (almost there)
Next
From: James M Moe
Date:
Subject: Re: Seaching without accents