Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M36984=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1TiqBA-0004ys-VJ
	for pgsql-sql@arkaria.postgresql.org; Wed, 12 Dec 2012 17:33:09 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M36984=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1TiqBA-0000uG-Do
	for pgsql-sql@arkaria.postgresql.org; Wed, 12 Dec 2012 17:33:08 +0000
Received: from magus.postgresql.org ([87.238.57.229])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>) id 1TiqB9-0000tJ-0b
	for pgsql-sql@postgresql.org; Wed, 12 Dec 2012 17:33:07 +0000
Received: from mail-pb0-f46.google.com ([209.85.160.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>) id 1TiqB6-0001hZ-QB
	for pgsql-sql@postgresql.org; Wed, 12 Dec 2012 17:33:06 +0000
Received: by mail-pb0-f46.google.com with SMTP id wy7so774764pbc.19
	for <pgsql-sql@postgresql.org>; Wed, 12 Dec 2012 09:33:03 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	bh=Yst8bNyQ6PyauGR246lzMbVe1qqOgQNb3kesL5onCtA=;
	b=z6eTMZQkR0UWjkgVHEw8qJxSOxVll+xmxCikMYQAZP0Eegj6XeWeBWr7B1pELRALKB
	cqXCc5BXoFSHtEorT8M3N7Z2r4oGhID56+pzfgoPNQLczbFW/tHG+JiG0hnJrBMzELCR
	SzB+IUwko/OBSGNo/2Oysi31Kw7NGE9OJxTvbcgSLt+w0qUaRQFYwq0VaHr4cHo9KnVk
	EBOW4i8Nsp7LWT84pVi6k1WfPUmuowm7gxPJccsLanVBTkWgbAHWuBmVD0HyPO1V2w5l
	2LqFSTLw8XY2wN1FbqTVaIKcs4kpgTovvLFjQmG18KwYTmtpM4VKq5e+BG4VcsCDusGe
	9S2A==
Received: by 10.68.237.135 with SMTP id vc7mr4630831pbc.2.1355333583601;
	Wed, 12 Dec 2012 09:33:03 -0800 (PST)
Received: from [192.168.200.187] ([199.48.193.159])
	by mx.google.com with ESMTPS id sy1sm15966138pbc.66.2012.12.12.09.33.01
	(version=SSLv3 cipher=OTHER); Wed, 12 Dec 2012 09:33:02 -0800 (PST)
Message-ID: <50C8BFCC.4060100@gmail.com>
Date: Wed, 12 Dec 2012 09:33:00 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: emilu@encs.concordia.ca
CC: pgsql-sql@postgresql.org
Subject: Re: Load UTF8@psql into latin1@mysql through JDBC
References: <50C8BB30.3000402@encs.concordia.ca>
In-Reply-To: <50C8BB30.3000402@encs.concordia.ca>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 12/12/2012 09:13 AM, Emi Lu wrote:
> Good morning,
> 
> Is there a simple way to load UTF8 data in psql to mysql(with latin1 
> encoding) through JDBC?

This would seem to be dependent on the MySQL JDBC adapter.