Re: cp1250 problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux