pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
windows-1250 encoding
2+ messages / 2 participants
[nested] [flat]

* windows-1250 encoding
@ 2004-05-03 12:10  Martin Zdila <zdila@antik.sk>
  0 siblings, 1 reply; 2+ messages in thread

From: Martin Zdila @ 2004-05-03 12:10 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: windows-1250 encoding
@ 2004-05-03 20:51  Peter Eisentraut <peter_e@gmx.net>
  parent: Martin Zdila <zdila@antik.sk>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2004-05-03 20:51 UTC (permalink / raw)
  To: Martin Zdila <zdila@antik.sk>; pgsql-admin

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?




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-05-03 20:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-03 12:10 windows-1250 encoding Martin Zdila <zdila@antik.sk>
2004-05-03 20:51 ` Peter Eisentraut <peter_e@gmx.net>

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