CP1250 to and from Unicode conversion, how? - Mailing list pgsql-novice

From Nikola Milutinovic
Subject CP1250 to and from Unicode conversion, how?
Date
Msg-id 005801c16211$41e07640$0a3ea8c0@ev.co.yu
Whole thread Raw
Responses Re: [GENERAL] CP1250 to and from Unicode conversion, how?
List pgsql-novice
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.

pgsql-novice by date:

Previous
From: "Duncan Adams (DNS)"
Date:
Subject: Re: moving postgres data
Next
From: "samsom, debra"
Date:
Subject: postgres copy