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

Migrate postgres databases from SQL_ASCII to UNICODE encoding

From: "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar>
To: pgsql-jdbc(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Migrate postgres databases from SQL_ASCII to UNICODE encoding
Date: 2004-07-17 20:03:31
Message-ID: 40F98613.1060405@sistemat.com.ar (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbcpgsql-sql
A simple question, we need to migrate many (>20) postgres databases from 
SQL_ASCII encoding to UNICODE encoding, over a 7.3.6 server.

With  Dump/Restore , we get an error (Invalid Unicode) in any field that 
has a 8 bits character coming from the SQL_ASCII , even setting the 
client_encoding to WIN, ISO-8859-1,  and others encodings.

I'm really worried about this problem since , we have many DBs to 
migrate and even with a ODBC program we can't port tables from 
Postgresql/SQL_ASCII to Postgresql/UNICODE.

Any suggestion will be *very* appreciated.

Regards,
Dario.


Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2004-07-17 21:18:16
Subject: Re: Migrate postgres databases from SQL_ASCII to UNICODE encoding
Previous:From: Gaetano MendolaDate: 2004-07-17 09:49:08
Subject: Re: FOR-IN-EXECUTE, why fail?

pgsql-admin by date

Next:From: Bruce MomjianDate: 2004-07-17 20:15:21
Subject: Re: [HACKERS] Point in Time Recovery
Previous:From: Tom LaneDate: 2004-07-17 19:18:26
Subject: Re: [HACKERS] Point in Time Recovery

pgsql-jdbc by date

Next:From: Tom LaneDate: 2004-07-17 21:18:16
Subject: Re: Migrate postgres databases from SQL_ASCII to UNICODE encoding
Previous:From: Kris JurkaDate: 2004-07-17 07:44:24
Subject: Re: patch: fix hopelessly broken decodeUTF8() method

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