- Архив списков рассылки pgsql-jdbc
От | Kubilay Osman Erdem |
---|---|
Тема | |
Дата | |
Msg-id | 26732.1078917713@www66.gmx.net обсуждение исходный текст |
Список | 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
В списке pgsql-jdbc по дате отправления: