Hello everyone,

Perhaps I'm a little late in answering your helpfull mail but I've been
very busy, therefore, I'll tell the story from today, saturday 17th of
december.

I first removed RedHat 6.1 and installed 6.0 again. Then I performed an
update to RedHat 6.1 and happily for me everything worked fine!!

Than I removed everything, installed RedHat 6.1 from scratch, and I did
have the same wrong sort order, we knew.
But as you suggested renaming the file /etc/sysconfig/i18n and restarting the
system gave the exact sort order and everything looks fine now. 
Still one question: can I be sure this program we rename is of no use
somewhere else
in the system ? If so, just what does it ?!


Second thing, many many thanks to everybody who helped me solving the problem!
Thanks!!

Frans



Sat, 18 Dec 1999 18:34:41 +0100
Frans Van Elsacker <fve@atbib.be>
Frans,

I supposed you wrote about postgres with locale support ?
If so, I'd recommend you to test LC_ALL env. variable.
Redhat 6.1 by default set is as en_US, at least in my setup
and I spend 30 minutes to figure out why I had the same problem
you described ( in my case I tried koi8-r ). 
When I set LC_ALL=koi8-r everything work fine.

	Regards,

		Oleg

On Sat, 18 Dec 1999, Frans Van Elsacker wrote:

> Date: Sat, 18 Dec 1999 18:34:41 +0100
> From: Frans Van Elsacker <fve@atbib.be>
> To: pgsql-hackers@postgreSQL.org
> Subject: [HACKERS] Cc: lamar.owen@wgcr.org
> 
> Hello everyone,
> 
> Perhaps I'm a little late in answering your helpfull mail but I've been
> very busy, therefore, I'll tell the story from today, saturday 17th of
> december.
> 
> I first removed RedHat 6.1 and installed 6.0 again. Then I performed an
> update to RedHat 6.1 and happily for me everything worked fine!!
> 
> Than I removed everything, installed RedHat 6.1 from scratch, and I did
> have the same wrong sort order, we knew.
> But as you suggested renaming the file /etc/sysconfig/i18n and restarting the
> system gave the exact sort order and everything looks fine now. 
> Still one question: can I be sure this program we rename is of no use
> somewhere else
> in the system ? If so, just what does it ?!
> 
> 
> Second thing, many many thanks to everybody who helped me solving the problem!
> Thanks!!
> 
> Frans
> 
> 
> 
> ************
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Sun, 19 Dec 1999 00:36:28 +0300 (MSK)
Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] Cc: lamar.owen@wgcr.org
Oleg Bartunov wrote:
 
> Frans,
 
> I supposed you wrote about postgres with locale support ?
> If so, I'd recommend you to test LC_ALL env. variable.
> Redhat 6.1 by default set is as en_US, at least in my setup
> and I spend 30 minutes to figure out why I had the same problem
> you described ( in my case I tried koi8-r ).
> When I set LC_ALL=koi8-r everything work fine.

The /etc/sysconfig/i18n scriptlet is a three-liner:
LANGUAGE=en_US
LC_ALL=en_US
LINGUAS=en_US

This script apparently is set up during the installation of RedHat -- it
does not belong to any installed RPM.  I am going to find out what these
envvars should be set to for 'normal' operation (where the definition of
'normal' varies.  There is little to no documentation on this
RedHat-ism.

I have also noted that the LC_ALL variable alters the collation even
when PostgreSQL is built WITHOUT --enable-locale -- on RedHat 6.1 the
locale support seems to be embedded into the glibc installation.

Again, little to no documentation that I have yet found.  Oh well.  Time
to do some reading.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Mon, 20 Dec 1999 12:11:04 -0500
Lamar Owen <admin@wgcr.org>
Re: [HACKERS] Cc: lamar.owen@wgcr.org
Oleg Bartunov wrote:
 
> Frans,
 
> I supposed you wrote about postgres with locale support ?
> If so, I'd recommend you to test LC_ALL env. variable.
> Redhat 6.1 by default set is as en_US, at least in my setup
> and I spend 30 minutes to figure out why I had the same problem
> you described ( in my case I tried koi8-r ).
> When I set LC_ALL=koi8-r everything work fine.

The /etc/sysconfig/i18n scriptlet is a three-liner:
LANGUAGE=en_US
LC_ALL=en_US
LINGUAS=en_US

This script apparently is set up during the installation of RedHat -- it
does not belong to any installed RPM.  I am going to find out what these
envvars should be set to for 'normal' operation (where the definition of
'normal' varies.  There is little to no documentation on this
RedHat-ism.

I have also noted that the LC_ALL variable alters the collation even
when PostgreSQL is built WITHOUT --enable-locale -- on RedHat 6.1 the
locale support seems to be embedded into the glibc installation.

Again, little to no documentation that I have yet found.  Oh well.  Time
to do some reading.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Mon, 20 Dec 1999 13:28:39 -0500
Lamar Owen <lamar.owen@wgcr.org>
Re: [HACKERS] Cc: lamar.owen@wgcr.org