| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
| Cc: | PostgreSQL general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: locale and spanish acute |
| Date: | 2001-09-13 00:52:27 |
| Message-ID: | Pine.LNX.4.30.0109130242080.694-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net http://funkturm.homeip.net/~peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ljb | 2001-09-13 01:08:29 | Re: pg_dump problem |
| Previous Message | Bruce Momjian | 2001-09-13 00:46:50 | Re: postgresql.com |