Locale and LIKE matching

From: Daniel Serodio <daniel(at)ibnetwork(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Locale and LIKE matching
Date: 2001-03-30 22:27:30
Message-ID: 985991250.3ac50852b3267@www.ibnetwork.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Soma Interesting 2001-03-30 22:34:21 RE: dynamic field names in a function.
Previous Message Jeff Eckermann 2001-03-30 22:09:58 RE: dynamic field names in a function.