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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin