pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
cp1250 problem 4+ messages / 3 participants [nested] [flat]
* cp1250 problem @ 2011-02-15 10:44 Lukasz Brodziak <lukasz.brodziak@gmail.com> 0 siblings, 1 reply; 4+ messages in thread From: Lukasz Brodziak @ 2011-02-15 10:44 UTC (permalink / raw) To: pgsql-admin 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). -- Ł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" ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: cp1250 problem @ 2011-02-15 11:26 Achilleas Mantzios <achill@matrix.gatewaynet.com> parent: Lukasz Brodziak <lukasz.brodziak@gmail.com> 0 siblings, 1 reply; 4+ messages in thread From: Achilleas Mantzios @ 2011-02-15 11:26 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: cp1250 problem @ 2011-02-15 22:00 Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de> parent: Achilleas Mantzios <achill@matrix.gatewaynet.com> 0 siblings, 1 reply; 4+ messages in thread From: Jan-Peter Seifert @ 2011-02-15 22:00 UTC (permalink / raw) To: ; +Cc: pgsql-admin 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: 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: cp1250 problem @ 2011-02-16 09:11 Achilleas Mantzios <achill@matrix.gatewaynet.com> parent: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de> 0 siblings, 0 replies; 4+ messages in thread From: Achilleas Mantzios @ 2011-02-16 09:11 UTC (permalink / raw) To: pgsql-admin Στις 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-02-16 09:11 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-02-15 10:44 cp1250 problem Lukasz Brodziak <lukasz.brodziak@gmail.com> 2011-02-15 11:26 ` Achilleas Mantzios <achill@matrix.gatewaynet.com> 2011-02-15 22:00 ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de> 2011-02-16 09:11 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox