X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id CCB9AD1B23C;
	Sat, 17 Jul 2004 16:54:22 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 49341-06; Sat, 17 Jul 2004 19:54:21 +0000 (GMT)
Received: from mail.svhost.com.ar (mail.svhost.com.ar [200.80.239.22])
	by svr1.postgresql.org (Postfix) with ESMTP id ECA10D1B248;
	Sat, 17 Jul 2004 16:54:19 -0300 (ADT)
Received: from sistemat.com.ar (devel.sistemat.com.ar [192.168.1.40])
	by mail.svhost.com.ar (Postfix) with ESMTP
	id ABA082443B; Sat, 17 Jul 2004 16:52:38 -0300 (ART)
Message-ID: <40F98613.1060405@sistemat.com.ar>
Date: Sat, 17 Jul 2004 17:03:31 -0300
From: "Dario V. Fassi" <software@sistemat.com.ar>
Organization: SISTEMATICA ingenieria de software srl
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: es, es-ar, en-us, en
MIME-Version: 1.0
To: pgsql-jdbc@postgresql.org, pgsql-admin@postgresql.org
Subject: Migrate postgres databases from SQL_ASCII  to UNICODE encoding
Content-Type: multipart/alternative;
	boundary="------------030600090905070909080309"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_20_30,
	HTML_MESSAGE, HTML_TITLE_EMPTY
X-Spam-Level: *
X-Archive-Number: 200407/200
X-Sequence-Number: 14268

This is a multi-part message in MIME format.
--------------030600090905070909080309
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit


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.



--------------030600090905070909080309
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<br>
A simple question, we need to migrate many (&gt;20) postgres databases
from SQL_ASCII encoding to UNICODE encoding, over a 7.3.6 server.
<br>
<br>
With&nbsp; 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,&nbsp; and others encodings.<br>
<br>
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.<br>
<br>
Any suggestion will be *very* appreciated.<br>
<br>
Regards,<br>
Dario.<br>
<div class="moz-signature"><small><br>
</small><br>
</div>
</body>
</html>

--------------030600090905070909080309--