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.
