From: | "kerdem" <kerdem(at)focusmr(dot)com> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | COPY Command UtfToLocal: could not convert UTF-8 |
Date: | 2004-03-10 11:16:49 |
Message-ID: | 000001c40691$2edb6010$07831aac@og131007 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kubilay Osman Erdem | 2004-03-10 11:21:53 | |
Previous Message | Adriaan Joubert | 2004-03-10 10:37:17 | Callable statements and rowsets |