Re: ~*, case insensitiveness and national chars

Marcin Owsiany <marcin@owsiany.pl> writes:
> Consider the following commands:

> ] create database a encoding='LATIN2';
> ] \connect a
> ] create table a (a character(1));
> ] insert into a values(chr(161));
> ] insert into a values(chr(177));
> ] select count(a) from a where a ~* chr(161);

> On PostgreSQL 7.3.2 this returns 2 (which is correct, since chr(161) and
> chr(177) are the same character in LATIN2, just different case), but on
> postgresql 7.2.2, this returns 1.

Case equivalences are determined by locale, not encoding.  Did you build
7.2 with locale support at all?  Did you initdb it in an appropriate
locale?

            regards, tom lane