Postgres Pro
Downloads
Home   >   mailing lists

Locale and LIKE matching - Mailing list pgsql-general

From Daniel Serodio
Subject Locale and LIKE matching
Date
Msg-id 985991250.3ac50852b3267@www.ibnetwork.com.br
Whole thread Raw
Responses Re: Locale and LIKE matching  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
    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

--
Daniel Serodio
daniel@ibnetwork.com.br

pgsql-general by date:

Previous
From: "Brent R. Matzelle"
Date:
Subject: Re: Memory Tuning
Next
From: "ADBAAMD"
Date:
Subject: Re: Locale and LIKE matching