"jef peeraer" <jef.peer...@telenet.be> writes:
> 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
Works for me.
It is true that ~* isn't very good about upper/lower case matching
for non-ASCII letters, but that doesn't seem to apply to your
example.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
