Re: Seaching without accents - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: Seaching without accents
Date
Msg-id Pine.LNX.4.33.0402021651120.20659-100000@css120.ihs.com
Whole thread Raw
In response to Seaching without accents  ("Augusto Cesar Castoldi" <castoldi@npd.ufsc.br>)
Responses RES: Seaching without accents  ("Augusto Cesar Castoldi" <castoldi@npd.ufsc.br>)
List pgsql-hackers
On Mon, 2 Feb 2004, Augusto Cesar Castoldi wrote:

> 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

Did you run initdb with --locale=pt_BR

???  It's got to be done at initdb time, after that it's too late to 
change it.



pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: 7.5 change documentation
Next
From: "scott.marlowe"
Date:
Subject: Re: Idea about better configuration options for sort memory