Thread: CP1250 to and from Unicode conversion, how?

Hi all.

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

--enable-recode              enable character set recode support
--enable-multibyte           enable multibyte character support
--enable-unicode-conversion  enable unicode conversion support

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

I mean, if all else fails, I'll dump database, run the dump through script/Java/C program to convert all CP-1250 chars
totheir Unicode equivalents and import it again. 

Hope someone will answer my question.

Nix.

> I have a database with text fields containing text with Windows CP-1250 encoding. How can I convert it to Unicode? I
havebuild 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