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
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 |