| From: | Markus Kickmaier <markus(dot)kickmaier(at)apus(dot)co(dot)at> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Encoding from CopyManager.copyIn() |
| Date: | 2009-07-22 16:30:25 |
| Message-ID: | 9709844.92821248280225595.JavaMail.root@donald.apus.co.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2009-07-22 19:41:10 | Re: Encoding from CopyManager.copyIn() |
| Previous Message | Greg Stark | 2009-07-21 22:59:14 | Re: IQ in Postgre |