[FWTools] import problems shp -> postgres using ogr2ogr

[christian.michels at eifelgeist.com]

Hi,

I have still problems with some shp files during import to postgres ... does anybody know what the following error message means ?

Thanx a lot for any help !

Regards

Chris

C:\>"C:\Program Files\FWTools1.0.0a7\bin\ogr2ogr.exe" -f PostgreSQL -nlt GEOMETRY -a_srs EPSG:4326 PG:"host=lidozrherm2
user=postgres dbname=erm_test" -nln aspwar_0601 D:\work\PostGIS\data\0601\aspwar.shp
ERROR 1: INSERT command for new feature failed.
ERROR:  invalid byte sequence for encoding "UNICODE": 0xf84e20

Command: INSERT INTO "aspwar_0601" (wkb_geometry , "area", "perimeter", "ld_", "ld_id", "rings_ok", "rings_nok", "id", "
ctry_id", "ctry_name", "chart_h", "chart_l", "chart_hl", "title", "line1", "line2", "line3", "line4", "line5", "line6",
"line7", "line8", "line9", "line10", "buffer", "bufferdist", "boundary", "color", "box", "selected") VALUES (GeometryFro
mText('POLYGON ((-7.999999523162842 45.0,-7.769400119781494 44.965751647949219,-7.539070129394531 44.931041717529297,-7.
309030532836914 44.895858764648438,-7.079259872436523 44.860221862792969,-6.849790096282959 44.824119567871094,-6.620600
22354126 44.787570953369141,-6.39169979095459 44.75054931640625,-6.292882442474365 44.734352111816406,-6.320351123809815
 44.6593017578125,-6.35613489151001 44.582225799560547,-6.398772239685059 44.5069580078125,-6.448061466217041 44.4338150
02441406,-6.503777027130127 44.36309814453125,-6.56566858291626 44.295097351074219,-6.633463859558106 44.230091094970703
,-6.706868171691895 44.168350219726563,-6.785568714141846 44.110122680664062,-6.869232177734375 44.055648803710938,-6.95
7508563995361 44.005153656005859,-7.050032138824463 43.958839416503906,-7.146421909332275 43.916896820068359,-7.24628353
1188965 43.879497528076172,-7.349210739135742 43.846797943115234,-7.454786777496338 43.818927764892578,-7.56258535385131
8 43.796001434326172,-7.672172546386719 43.778118133544922,-7.783108234405518 43.765350341796875,-7.894947528839111 43.7
5775146484375,-7.998526573181152 43.755355834960938,-8.096386909484863 43.755149841308594,-8.100709915161133 43.75514221
1914063,-8.394292831420898 43.754528045654297,-8.398687362670898 43.7545166015625,-8.400773048400879 43.754512786865234,
-8.694358825683594 43.753913879394531,-8.700836181640625 43.753902435302734,-8.994425773620606 43.753318786621094,-9.000
901222229004 43.753307342529297,-9.29449462890625 43.752738952636719,-9.300965309143066 43.752727?
ERROR 1: Terminating translation prematurely after failed
translation of layer aspwar