pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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