From owner-freebsd-questions  Mon Mar  8  4:49:37 1999
Delivered-To: freebsd-questions@freebsd.org
Received: from sibfair.nsc.ru (sibfair.nsc.ru [194.226.171.21])
	by hub.freebsd.org (Postfix) with ESMTP id 6D47314CF2
	for <freebsd-questions@FreeBSD.ORG>; Mon,  8 Mar 1999 04:49:12 -0800 (PST)
	(envelope-from vadim@sibfair.nsc.ru)
Received: from sibfair.nsc.ru (vadim [192.168.2.4])
	by sibfair.nsc.ru (8.8.5/8.8.5) with ESMTP id SAA17246
	for <freebsd-questions@FreeBSD.ORG>; Mon, 8 Mar 1999 18:55:56 +0600
Message-ID: <36E3C711.AB5C4285@sibfair.nsc.ru>
Date: Mon, 08 Mar 1999 18:48:17 +0600
From: Vadim Valiakhmetov <vadim@sibfair.nsc.ru>
Organization: Siberian Line Co.
X-Mailer: Mozilla 4.06 [en] (Win95; I)
MIME-Version: 1.0
To: freebsd-questions@FreeBSD.ORG
Subject: Postgress case insensitive search on FreeBSD3.0
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

Hello!

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@sibfair.nsc.ru
Sysadmin, SibLine Co.





To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message