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

Reply via email to