Re: CP1250 to and from Unicode conversion, how?

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: Nikola(dot)Milutinovic(at)ev(dot)co(dot)yu
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: CP1250 to and from Unicode conversion, how?
Date: 2001-11-01 01:01:15
Message-ID: 20011101100115E.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

> I have a database with text fields containing text with Windows CP-1250 encoding. How can I convert it to Unicode? I have build the database with

Sorry, the conversion between CP-1250 and Unicode is not currently
supported, nor in 7.2. Actually adding that would be pretty easy, but
we are in the beta freeze phase and can not add a new functionality.

BTW, CP-1250 is equivalent to ISO-8859-2? If so, you could use the
encoding name "LATIN2" instead of WIN1250 and it supports the
converion to/from UNICODE.

> Also, how can I enter a string containing Unicode chars from "psql"? What is the Unicode escape sequence?

No idea. Why not using Unicode aware terminals? I use emacs + mule-ucs.
--
Tatsuo Ishii

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Super Duty 2001-11-01 03:14:51 two processors or more memory?
Previous Message Roderick A. Anderson 2001-10-31 23:37:47 Re: Postgresql Copy

Browse pgsql-novice by date

  From Date Subject
Next Message Sharon Cowling 2001-11-01 02:39:04 Update function
Previous Message Josh Berkus 2001-10-31 21:48:47 Re: Returning data from function