Hi Augusto,
> How can I configure postgreSQL to search without acents?
> Is PostgreSQL have this support?
>
There isn't a specific function in postgresql. Maybe you could implement it in PL/Perl
or any other PL/* language.
> SELECT * FROM test WHERE name LIKE _tes%_
>
> And it should return va
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
>
n 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: [HA
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:
