Seaching without accents

From: "Augusto Cesar Castoldi" <castoldi(at)npd(dot)ufsc(dot)br>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Seaching without accents
Date: 2004-02-02 23:20:38
Message-ID: 001201c3e9e3$2b0bfdc0$b709a296@npd.ufsc.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-02-02 23:21:52 Re: [PATCHES] log session end - again
Previous Message Andrew Dunstan 2004-02-02 23:02:49 Re: [PATCHES] log session end - again