Thread: locale problem

locale problem

From
Tomasz Prus
Date:
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