Skip site navigation (1) Skip section navigation (2)

Re: cp1250 problem

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: cp1250 problem
Date: 2011-02-15 11:26:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Στις Tuesday 15 February 2011 12:44:31 ο/η Lukasz Brodziak έγραψε:
> Hello,
> How can I set PostgreSQL locale and encoding to be pl_PL.cp1250 all I
> can do is pl_PL.UTF-8.
> I have PG 8.2.4 on Ubuntu 10.04 (polish version).

I had similar issues with the Greek ISO locale/encoding and the UTF one.
If i had known earlier i would have implemented UTF since day one.
UTF-8 support is pretty mature, so i dont see any reason for people to
hold back to ISO encodings (in year 2011!)

The locale for your whole cluster is defined in postgresql.conf.
(and i believe the value is inherited by the ENV variables at initdb time)
Now each database has its *own* encoding.
psql -l 
lists who has what.

> -- 
> Łukasz Brodziak
> "What if everyting around You isn't quite as it seems,
> What if all the world You think You know is an inelaborate dream
> When You look at Your reflection is that all you want it to be
> What if You could look right through the cracks
> Would You find Yourself...... Find Yourself afraid to see"

Achilleas Mantzios

In response to


pgsql-admin by date

Next:From: Kevin GrittnerDate: 2011-02-15 18:00:06
Subject: Re: pg_dump not working
Previous:From: Lukasz BrodziakDate: 2011-02-15 10:44:31
Subject: cp1250 problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group