locale problem

From: Tomasz Prus <to(dot)prus(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: locale problem
Date: 2010-11-30 15:03:33
Message-ID: AANLkTin4CO0+OKRjcE91Hoxv0abZvbNV6WEvOP1fJ1cb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-11-30 15:06:49 Re: Setting Schema on Restore
Previous Message 100-eti 2010-11-30 13:06:14 Re: Postgres service won't start, doesn't log any errors