The following bug has been logged online:
Bug reference: 5220
Logged by: jef peeraer
Email address: jef.peeraer@telenet.be
PostgreSQL version: 8.3
Operating system: linux
Description: regexp fails on punctuation characters
Details:
my lc_locale is set to en_US.UTF-8
if i do a search like this
select * from contacten
where naam ~* 'RÃN'
and my contacten table contains a column naam with the value
RÃNTGEN TECHNISCHE DIENST NV
-> it won't find it
the same query with
naam ILIKE '%RÃN%' works perfectly