Re: Searching accented words

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: João Paulo Batistella <batistellabr(at)yahoo(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Searching accented words
Date: 2002-07-24 20:49:09
Message-ID: 13800.1027543749@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?q?Jo=E3o=20Paulo=20Batistella?= <batistellabr(at)yahoo(dot)com(dot)br> writes:
> How can I perform a query that return the two rows, no
> matter I pass 'Jos' or 'Jose' as parameter?

If your locale is set up correctly, perhaps upper() would return
JOSE for both, and then you could search on upper(name) = 'JOSE'.
(You can make this fast with an index on upper(name).)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Beth Gatewood 2002-07-24 21:23:10 Re: COPY taking forever, I just want to end it!
Previous Message Tom Lane 2002-07-24 20:41:20 Re: COPY taking forever, I just want to end it!