Re: BUG #3525: Lithuanian characters doesn't work in queries with regular expressions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rolandas Rudomanskis" <rolandasr(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3525: Lithuanian characters doesn't work in queries with regular expressions
Date: 2007-08-09 23:12:42
Message-ID: 3395.1186701162@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Rolandas Rudomanskis" <rolandasr(at)gmail(dot)com> writes:
> Description: Lithuanian characters doesn't work in queries with
> regular expressions

> The database is set to unicode. Debian locale is utf-8.

Yeah, the regex code doesn't handle localization issues (such as
case-insensitive matching) correctly for multibyte characters.
Can you use a single-byte encoding? Alternatively, I believe
case-insensitive LIKE matching works for this.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-08-10 03:18:16 Re: BUG #3523: plpython crash
Previous Message Peter Koczan 2007-08-09 18:55:00 Re: BUG #3504: Some listening sessions never return from writing, problems ensue