Обсуждение: windows-1250 encoding

Hello

How can one set character encoding in the database to windows-1250? I am
using postgresql 7.2.1-2woody4 (on debian).

create database somedb with encoding = 'windows-1250';
ERROR:  CREATE DATABASE: invalid backend encoding

I just need to order selected rows by some column witch windows-1250
encoded text.

Or, it would be beven etter if I could change the encoding on the
existing database, but unfortunately in postgresql 7.2 there is no ALTER
DATABASE ... Any advice?

Thanks in advance

--
Best regards

Martin Zdila
Developer
EpiSoftware Slovakia Ltd.
Prazska 4, 040 11  Kosice
cellular: +421 908 363 848
phone: +421 55 643 9954
fax: +421 55 643 9954
mailto:m.zdila@episoftware.com
http://www.episoftware.com

Martin Zdila wrote:
> How can one set character encoding in the database to windows-1250?

Evidently you cannot.

> I just need to order selected rows by some column witch windows-1250
> encoded text.

If you have windows-1250 data on the client side, then declare your
client encoding, create your database with a supported encoding, and
the conversion will be done for you.

If you really have windows-1250 data already in your database, then, uh,
how did you do that, considering that that encoding is not supported
for databases?