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