The following bug has been logged online: Bug reference: 5220 Logged by: jef peeraer Email address: jef.peer...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs