Quoting Martín Marqués <martin@bugs.unl.edu.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 "á"
> > (á)or "ã" (ã) (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@ibnetwork.com.br