Обсуждение: 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?