Skip site navigation (1) Skip section navigation (2)

Postgress case insensitive search on FreeBSD3.0

From: Vadim Valiakhmetov <vadim(at)sibfair(dot)nsc(dot)ru>
To: pgsql-ports(at)hub(dot)org
Subject: Postgress case insensitive search on FreeBSD3.0
Date: 1999-03-08 12:51:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-ports

I have encountered strange behaviour of Postgresql-6.4.2 server
(installed on FreeBSD3.0 from distributive) when I was trying to do
case-insensitive search in simplest text table (without indexes)
containing sequence of strings of characters from national alphabet
(Russian KOI8-R and CP1251 character sets). The following example query
does not do case insensitive search for both KOI8-R and CP1251:

select firm from plan  where  firm ~* ('substring')   order by  firm asc

Here 'substring' consists of russian characters, of course.

I believe, that my russian locale  properly configured and working, as
well as postmaster compiled with option --enable-locale. Environment
variables $LC_CTYPE and $LC_COLLATE also defined. For instance,
operators upper('substring') and lower ('substring') both working
correctly with russian characters.

Just the same example query does case insensitive search under RedHat
Linux 4.2 with glibc2 installed. All postmaster settings were the same
as for FreeBSD.

Can anybody clarify this situation ?

Thanks in advance, and sorry for bad english.

Vadim Valiakhmetov           mailto:vadim(at)sibfair(dot)nsc(dot)ru
Sysadmin, SibLine Co.

pgsql-ports by date

Next:From: AshokDate: 1999-03-08 16:25:24
Subject: Problem in installation
Previous:From: Palle GirgensohnDate: 1999-03-07 17:00:45
Subject: Re: [PORTS] Port Bug Report: .so file loading ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group