Skip site navigation (1) Skip section navigation (2)

CP1250 to and from Unicode conversion, how?

From: "Nikola Milutinovic" <Nikola(dot)Milutinovic(at)ev(dot)co(dot)yu>
To: "PostgreSQL novice" <pgsql-novice(at)postgresql(dot)org>, "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Subject: CP1250 to and from Unicode conversion, how?
Date: 2001-10-31 13:37:59
Message-ID: 005801c16211$41e07640$0a3ea8c0@ev.co.yu (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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 have build 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 to their Unicode equivalents and import it again.

Hope someone will answer my question.

Nix.

Responses

pgsql-novice by date

Next:From: samsom, debraDate: 2001-10-31 15:47:21
Subject: postgres copy
Previous:From: Duncan Adams (DNS)Date: 2001-10-31 09:58:56
Subject: Re: moving postgres data

pgsql-general by date

Next:From: Meenatchi AnbuchelvanDate: 2001-10-31 15:02:04
Subject: Re: DOes PostgreSQL support UInt64?
Previous:From: tonyDate: 2001-10-31 13:05:16
Subject: function gurus...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group