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.0109130109320.694-100000@peter.localdomain
Whole thread Raw
In response to 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:

> 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.

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


pgsql-general by date:

Previous
From: Graham Leggett
Date:
Subject: Re: Error: Bad Timestamp Format
Next
From: Martín Marqués
Date:
Subject: Re: locale and spanish acute