- Mailing list 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.




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