Re: locale and spanish acute

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: locale and spanish acute
Date: 2001-09-12 23:08:06
Message-ID: 20010912230808.978352AB45@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-09-12 23:10:37 Re: locale and spanish acute
Previous Message Graham Leggett 2001-09-12 22:55:30 Re: Error: Bad Timestamp Format