SEO

#1 (**permalink**) 04-16-2008, 12:52 AM

I use PostgreSQL 8.2 for WinXP (SP2).
I try to use "postgresql-jdbc-8.2-505-copy-20070719.jdbc3.jar"
(from http://kato.iki.fi/sw/db/postgresql/jdbc/copy/):

FileInputStream fs = new FileInputStream("D://t.txt");
((PGConnection)con).getCopyAPI().copyIntoDB("COPY table1 FROM
STDIN", fs);
fs.close();

but have error: 'org.postgresql.util.PSQLException: ERROR: invalid byte
sequence for encoding "UTF8": 0xa0'.

file 'D://t.txt' used WIN866 encoding.
DB used UTF8 encoding.

Command successfully runs in psql-console:
set client_encoding to WIN866;
copy table1(nn) from 'd://t.txt';

How can I solve this problem?

--
View this message in context: http://www.nabble.com/JDBC-COPY-erro...html#a12236825
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#2 (**permalink**) 04-16-2008, 12:52 AM

Hi!

2007/8/20, ttvvaa <ttvvaa@gmail.com>:
> I use PostgreSQL 8.2 for WinXP (SP2).
> I try to use "postgresql-jdbc-8.2-505-copy-20070719.jdbc3.jar"
> (from http://kato.iki.fi/sw/db/postgresql/jdbc/copy/):
>
> FileInputStream fs = new FileInputStream("D://t.txt");
> ((PGConnection)con).getCopyAPI().copyIntoDB("COPY table1 FROM
> STDIN", fs);
> fs.close();
>
> but have error: 'org.postgresql.util.PSQLException: ERROR: invalid byte
> sequence for encoding "UTF8": 0xa0'.
>
> file 'D://t.txt' used WIN866 encoding.
> DB used UTF8 encoding.
>
> Command successfully runs in psql-console:
> set client_encoding to WIN866;
> copy table1(nn) from 'd://t.txt';
>
> How can I solve this problem?

JDBC copy does not know the encoding in the provided bytestream. Thus
you have to convert the data to encoding used by server by yourself,
before feeding it to copy.

--
Kalle Hallivuori +358-41-5053073 http://korpiq.iki.fi/

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

#3 (**permalink**) 04-16-2008, 12:52 AM

Thanks for answer!
I convert text-file to UTF-8 and successed copy.

Kalle Hallivuori wrote:
>
> Hi!
> JDBC copy does not know the encoding in the provided bytestream. Thus
> you have to convert the data to encoding used by server by yourself,
> before feeding it to copy.
>
> --
> Kalle Hallivuori +358-41-5053073 http://korpiq.iki.fi/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
>

--
View this message in context: http://www.nabble.com/JDBC-COPY-erro...html#a12261732
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

JDBC COPY error encoding