Re: Locale and LIKE matching

Quoting Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>:

> On Saturday 31 March 2001 01:27, you wrote:
> > Hi! I'd like to know if the LIKE operator is locale-aware when
> matching
> > strings. Specifically, I'd like to have "... LIKE '%a%'" match "á"
> > (&aacute;)or "ã" (&atilde;) (these are ISO8859-1, pt_BR chars). Is
> this
> > possible? I've compiled postgresql 7.0.2 with --enable-locale
> > --enable-multibyte, and created the DB with latin1 encoding, but it
> still
> > doesn't work as I'd like. TIA
>
> Are you sure that your locale is latin1? Check with the á, because I
> think
> the latin1 is not for Portugues, but spanish, but..... I may be wrong.

latin1 is the one for most 'accented' languages, Spanish and Portuguese
included... Saludos! :)

--
Daniel Serodio
daniel(at)ibnetwork(dot)com(dot)br