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