Encoding from CopyManager.copyIn() - Mailing list pgsql-jdbc

From Markus Kickmaier
Subject Encoding from CopyManager.copyIn()
Date
Msg-id 9709844.92821248280225595.JavaMail.root@donald.apus.co.at
Whole thread Raw
Responses Re: Encoding from CopyManager.copyIn()  (Kris Jurka <books@ejurka.com>)
Re: Encoding from CopyManager.copyIn()  (Daniel Migowski <dmigowski@ikoffice.de>)
Re: Encoding from CopyManager.copyIn()  (Daniel Migowski <dmigowski@ikoffice.de>)
List pgsql-jdbc
Hello,

I'm using the copyIn() function of the CopyManager. It works fine until I don't use an "umlaut" like ü. Then i get an
PSQLException:

org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0xfc

My code looks like follows:

ByteArrayOutputStream output = new ByteArrayOutputStream();
PrintWriter writer = new PrintWriter(output);
writer.println("abcüäö");
writer.flush();
ByteArrayInputStream input = new ByteArrayInputStream(output.toByteArray());
long result = ((PGConnection) con_).getCopyAPI().copyIn(statement, input);

After searching at google i found out that this is an encoding problem. The database doesn't know what charset I'm
using.

Any suggestion how i can specify the encoding i want to use?

BR, Markus

pgsql-jdbc by date:

Previous
From: Greg Stark
Date:
Subject: Re: IQ in Postgre
Next
From: Kris Jurka
Date:
Subject: Re: Encoding from CopyManager.copyIn()