ÎÏÎÏ Wednesday 16 February 2011 00:00:10 Î/Î Jan-Peter Seifert ÎÎÏÎÏÎ: > Hello, > > Am 15.02.2011 12:26, schrieb Achilleas Mantzios: > > ÎÏÎÏ 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). > > There are no code pages in Ubuntu. The nearest what you can get seems to > be encoding LATIN2 ( and a compatible locale ). These charsets are NOT > identical though. > > > The locale for your whole cluster is defined in postgresql.conf. > > Not really - LC_COLLATE and LC_CTYPE are set during initialization of > the cluster by initdb. You can verify the settings with pg_controldata: > That's true. Thanx. > http://www.postgresql.org/docs/8.2/interactive/app-pgcontroldata.html > > As of PostgreSQL v8.4 you can specify these two locale settings > different from the server's settings (for each database). > If you plan to upgrade your PostgreSQL major server version beware of > the removal of some implicit data type casts among other changes as of 8.3. > > Peter > > -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
