I have a database in sql_ascii that I need to convert to Unicode. I tried using
pg_dump -Fc .. but it fails on certain characters. like this one "è"
How can I get the data transferred?


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Some help please?? :-) Anyone?


-----Original Message-----
From: pgsql-general-owner (AT) postgresql (DOT) org on behalf of Jason Tesser
Sent: Wed 10/13/2004 10:00 AM
To: pgsql-general (AT) postgresql (DOT) org
Cc:
Subject: [GENERAL] converting database to unicode
I have a database in sql_ascii that I need to convert to Unicode. I tried using
pg_dump -Fc .. but it fails on certain characters. like this one "è"
How can I get the data transferred?


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend





---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

On Fri, Oct 15, 2004 at 07:59:19AM -0500, Jason Tesser wrote:
Did you try recoding the plain-text dump using recode or iconv?


--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No es bueno caminar con un hombre muerto"


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

On Fri, Oct 15, 2004 at 09:36:42AM -0500, Jason Tesser wrote:
Something like

pg_dump --username=xxx --dbname=yyy filename
recode latin1..utf8 filename
createdb -E utf8 database
psql < filename

(assuming the database is Latin1, a.k.a. iso-8859-1. Update accordingly.)

I don't think you can do it with a -Fc or -Ft format. In fact, if you
do that, the dump will be corrupted.


Huh, now I know why your name was so familiar to me (see sig)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Jason Tesser: You might not have understood me or I am not understanding you.
Paul Thomas: It feels like we're 2 people divided by a common language...


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html