locale problem - Mailing list pgsql-admin

From Tomasz Prus
Subject locale problem
Date
Msg-id AANLkTin4CO0+OKRjcE91Hoxv0abZvbNV6WEvOP1fJ1cb@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hi,

I have problem because some German characters are displayed
incorrectly on my website. This happend only on our live server but
everything is ok on our test and stage servers. Only one difference
that I found between Postgres instances on those servers is that :

test and stage servers have:

psql=> SHOW LC_CTYPE;
  lc_ctype
-------------
 en_US.UTF-8
(1 row)

springloops=> SHOW LC_COLLATE;
 lc_collate
-------------
 en_US.UTF-8
(1 row)


but live server has:

psql=# SHOW LC_CTYPE;
  lc_ctype
-------------
 pl_PL.UTF-8
(1 row)

springloops=# SHOW LC_COLLATE;
 lc_collate
-------------
 pl_PL.UTF-8
(1 row)
2010-11-24


Em I right, is this can be a reason? How can I change this properly?

Best regards,
Tomasz Prus

pgsql-admin by date:

Previous
From: 100-eti
Date:
Subject: Re: Postgres service won't start, doesn't log any errors
Next
From: Tom Lane
Date:
Subject: Re: Setting Schema on Restore