Re: LC_COLLATE problem between linux distros

On Fri, Oct 04, 2002 at 01:48:49AM -0400, Craig Longman wrote:
> On Fri, 2002-10-04 at 01:37, Tom Lane wrote:
> > I'd have imagined that too, but it seems not; leastwise the error
> > message is pretty definitive about what Postgres is being told by
> > setlocale(). Look in /usr/share/locale/ --- is there an en_US
> > subdirectory? If not, maybe you missed installing some locale RPMs?
>
> initially, there wasn't in /use/share/locale, only:
> en, en_AU, en_GB, en_RN
>
> i created a link for en_US to en, but that didn't seem to help.
>
> perhaps i can copy the en_US directory over from a redhat install i
> have, or even duplicate the whole 'en' directory in there? i'll try
> that. maybe the debian packagers simply assume that en_US is the
> definitive en and doesn't need to be further qualified. this is awfully
> strange.

We have a similar setup here where only the directories shown appear. But
en_US seems to work fine here. have you tried: dpkg-reconfigure locales

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.