Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 08 Mar 1999 18:48:17 +0600
From:      Vadim Valiakhmetov <vadim@sibfair.nsc.ru>
To:        freebsd-questions@FreeBSD.ORG
Subject:   Postgress case insensitive search on FreeBSD3.0
Message-ID:  <36E3C711.AB5C4285@sibfair.nsc.ru>

next in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?36E3C711.AB5C4285>