From: Emi Lu <emilu@encs.concordia.ca>
To: Adrian Klaver <adrian.klaver@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Load UTF8@psql into latin1@mysql through JDBC
Date: Wed, 12 Dec 2012 13:06:57 -0500
Message-ID: <50C8C7C1.6050705@encs.concordia.ca> (raw)
In-Reply-To: <50C8C325.3070809@encs.concordia.ca>
References: <50C8BB30.3000402@encs.concordia.ca>
<50C8BFCC.4060100@gmail.com>
<50C8C325.3070809@encs.concordia.ca>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
On 12/12/2012 12:47 PM, Emi Lu wrote:
>>> 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.
>>
>>> From here:
>>
>> http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-charsets.html
>>
>>
>> "All strings sent from the JDBC driver to the server are
>> converted automatically from native Java Unicode form to
>> the client character encoding, including all queries sent.... "
>
> This does not help. The reason I asked this is because through mybatis +
> JDBC, loading data from psql@utf8 to mysql@latin1, the french character
> cannot be auto-loaded.
>
JAVA codes work for most of characters, but not "-È". Someone knows why
the following codes cannot load "-È" to mysql@latin1?
Thanks a lot!
--
public static String utf8_to_latin1(String str)
throws Exception
{
try
{
String stringToConvert = str;
byte[] convertStringToByte = stringToConvert.getBytes("UTF-8");
return new String(convertStringToByte, "ISO-8859-1");
}catch(Exception e)
{
log.error("utf8_to_latin1 Error: " + e.getMessage());
log.error(e);
throw e;
}
}
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: emilu@encs.concordia.ca, adrian.klaver@gmail.com
Subject: Re: Load UTF8@psql into latin1@mysql through JDBC
In-Reply-To: <50C8C7C1.6050705@encs.concordia.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox