Re: Seaching without accents

From: James M Moe <jimoe(at)sohnen-moe(dot)com>
To: Postgresql General Mail List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Seaching without accents
Date: 2004-01-28 17:04:36
Message-ID: 4017EBA4.4070908@sohnen-moe.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Augusto Cesar Castoldi wrote:
> How can I configure postgreSQL to search without acents?
>
> Table “test”
>
> Clumns: name , values:
> Test
> Test
> tést
> Tést
>
Since those are actually different characters that only look the
same, you would have to use another approach:
select * from test where name like 't_st%';
or
select * from test where name like 'tést%' or name like 'test%' ...

--
jimoe at sohnen-moe dot com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message MaRCeLO PeReiRA 2004-01-28 17:51:17 7.3.4 freezing
Previous Message Chris Travers 2004-01-28 14:52:19 Re: Interest in database-based email?