Thread:
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
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
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
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