COPY Command UtfToLocal: could not convert UTF-8

From: "kerdem" <kerdem(at)focusmr(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: COPY Command UtfToLocal: could not convert UTF-8
Date: 2004-03-10 11:16:49
Message-ID: 000001c40691$2edb6010$07831aac@og131007
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I installed PG 7.3.4 and created DB with encoding “LATIN10” . I tried
to import Flat-File with Copy Command

String delimeter ;";

String FILEPATH ="/home/kerdem/upstream/LIQ.txt";

String pgcopy ="copy public.liq_import from '"+FILEPATH+"' with
delimiter '"+delimeter+"' NULL AS '' ";

pstmt = con.prepareStatement(pgcopy);

pstmt.executeUpdate();

pstmt.close();

I am getting

WARNING: copy: line 2, UtfToLocal: could not convert UTF-8 (0xe47469).
Ignored
WARNING: copy: line 7, UtfToLocal: could not convert UTF-8 (0xf66765).
Ignored
WARNING: copy: line 7, UtfToLocal: could not convert UTF-8 (0xe4676e).
Ignored
WARNING: copy: line 8, UtfToLocal: could not convert UTF-8 (0xe4747a).
Ignored
WARNING: copy: line 12, UtfToLocal: could not convert UTF-8 (0xc472).
Ignored
WARNING: copy: line 13, UtfToLocal: could not convert UTF-8 (0xe4727a).
Ignored
.......
....
..

I cannot import special letter like (ä,ß,ü,ö).

But wenn I use same command from psql console in DB I can import all
of the special letter,

copy public.liq_import from '/home/kerdem/upstream/LIQ.txt' delimiter
';' NULL as '' ;

I would appreciate any help.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kubilay Osman Erdem 2004-03-10 11:21:53
Previous Message Adriaan Joubert 2004-03-10 10:37:17 Callable statements and rowsets