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.

--
+++ NEU bei GMX und erstmalig in Deutschland: TÜV-geprüfter Virenschutz +++
100% Virenerkennung nach Wildlist. Infos: http://www.gmx.net/virenschutz