Re: locale and spanish acute - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: locale and spanish acute
Date
Msg-id Pine.LNX.4.30.0109130242080.694-100000@peter.localdomain
Whole thread Raw
In response to Re: locale and spanish acute  (Martín Marqués <martin@bugs.unl.edu.ar>)
Responses Re: locale and spanish acute
List pgsql-general
Martín Marqués writes:

> On Mié 12 Sep 2001 20:10, you wrote:
> > Martín Marqués writes:
> > > I'm doing some searches with LIKE and have a problem with words with
> > > acute vocals. I would like más to be treated the same way as mas, and
> > > vice-verse.
> > >
> > > Is this because I don't have the locale set correctly?
> >
> > No, it's because it doesn't work that way.  What you probably want to do
> > is "accent-fold" your strings before sending them through pattern
> > matching.
>
> What does "accent-fold" mean?

Convert all accented characters to some other characters in a way that is
meaningful to you.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: postgresql.com
Next
From: lbayuk@mindspring.com (ljb)
Date:
Subject: Re: pg_dump problem