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

From Daniel Migowski
Subject Re: Encoding from CopyManager.copyIn()
Date
Msg-id 4A6987D4.2080406@ikoffice.de
Whole thread Raw
In response to Encoding from CopyManager.copyIn()  (Markus Kickmaier <markus.kickmaier@apus.co.at>)
List pgsql-jdbc
Or, in your case you have to wrap the OutputStream in an
OutputStreamWriter (which has the encoding parameter in the constructor).

best
Daniel

Markus Kickmaier schrieb:
> 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: Daniel Migowski
Date:
Subject: Re: Encoding from CopyManager.copyIn()
Next
From: nmset@netcourrier.com
Date:
Subject: SSL - NonValidatingFactory