Re: [SQL] Re: "ORDER BY" issue - is this a bug?

On Mon, 11 Sep 2000, Lamar Owen wrote:

> Max Pyziur wrote:
> > I dropped my databases, uninstalled the 7.0.2-2 rpms and installed 6.5.3 rpms on
> > my development RH6.2 Linux 2.2.14-5.0 system and I still get the anomalous query
> > result on that box.
>
> This is a RedHat 6.2 locale problem.  Set LC_COLLATE=C and see if that
> fixes things.

That didn't do it.  But I'll tell you what did give me the
(original) results for which I was looking.  Looking through the various
*rc files which get called in the stock RH6.2 installation I saw that
there was a /etc/profile.d/lang.sh file (for bash shells) and lang.csh
(for csh shells).  I moved the lang.sh to lang.sh.bak (since the login
initialization script looks for /etc/profile.d/*sh files), shutdown
postmaster and restarted and now I'm getting the results I got before.

The thing which I'm concerned about is doing a 'env | sort' doesn't show
any of the LC_xxx variable settings.  Nor does 'echo $LC_COLLATE'.  What
command can I use to "expose" these settings to make sure that I don't
run into a similar situation?

Much thanks to you and tom lane (in his ferlinghetti way) for helping me
out of this one (at least to get the original results I had).

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


Max Pyziur                                     BRAMA - Gateway Ukraine
pyz@brama.com                                  http://www.brama.com/