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
