The following bug has been logged online:
Bug reference: 5220
Logged by: jef peeraer
Email address: jef(dot)peeraer(at)telenet(dot)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