Re: Searching accented words - Mailing list pgsql-general

=?iso-8859-1?q?Jo=E3o=20Paulo=20Batistella?= <batistellabr@yahoo.com.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