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.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])