Yes, I tried to initdb isso locale too.
Didn’t worked, now my linux is configured with pt_BR, than in initdb appers there, "using locale pt_BR" Why it doesn't work? Did you tried it? Is there something related with "Indexes" ? Do I need to create one? If I create an Index, it will save the rows in 'index' without acents? Thanks, Augusto -----Mensagem original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Em nome de scott.marlowe Enviada em: Monday, February 02, 2004 9:52 PM Para: Augusto Cesar Castoldi Cc: [EMAIL PROTECTED] Assunto: Re: [HACKERS] Seaching without accents 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]) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
