The following bug has been logged on the website:

Bug reference:      6457
Logged by:          Albert Cieszkowski
Email address:      albert(dot)cieszkowski(at)cc(dot)com(dot)pl
PostgreSQL version: 9.0.6
Operating system:   CentOS 5.x
Description:        

OS, base and client encoding UTF-8:

peimp=> select 'Świnoujście' ~* '\mŚwinoujście\M';
 ?column?
----------
 f
(1 row)

peimp=> select 'Świnoujście' ~* '\AŚwinoujście\Z';
 ?column?
----------
 t
(1 row)

but:

peimp=> select 'Mróz' ~* '\mmróZ\M';
 ?column?
----------
 t
(1 row)

peimp=> select 'Mróz' ~* '\AmróZ\Z';
 ?column?
----------
 t
(1 row)

I believe it is connected with bug #5766 and #3433.

Responses

• Re: BUG #6457: Regexp not processing word (with special characters on ends) correctly (UTF-8) at 2012-02-14 15:27:05 from Tom Lane
• Re: BUG #6457: Regexp not processing word (with special characters on ends) correctly (UTF-8) at 2012-02-14 18:28:11 from Tom Lane

pgsql-bugs by date

Next:	From: Tom Lane	Date: 2012-02-14 15:27:05
	Subject: Re: BUG #6457: Regexp not processing word (with special characters on ends) correctly (UTF-8)
Previous:	From: Heikki Linnakangas	Date: 2012-02-14 12:41:14
	Subject: Re: BUG #6452: psql: can't change client encoding from the command line