[postgis-users] shape to postgis inporter fails or crashes

Paul Ramsey pramsey at opengeo.org
Thu Sep 30 10:24:52 PDT 2010


Except, to my knowledge, the OSM files are UTF8 encoded, so I'm
surprised you are getting troubles loading them as UTF8.

On Thu, Sep 30, 2010 at 10:22 AM, Paul Ramsey <pramsey at opengeo.org> wrote:
> Just use the -w switch to specify WINDOWS-1252 as your encoding.
> Should work fine from there.
>
> P.
>
> BTW, it shouldn't crash, it should just stop and show the error. Is
> that what it is doing, or do you get honest-to-god coredumps?
>
> On Thu, Sep 30, 2010 at 10:17 AM, Clay, Bruce <bclay at ball.com> wrote:
>> I am trying to load OpenStreetMap and GDAM data from the shapefiles that
>> were posted on the network.  Some of the work file but those with special
>> characters often fail or in came cases the application crashes.
>>
>>
>>
>> The error message  get is -  Unable to convert field value "<some osm name>"
>> to UTF-8: iconv reports "Illegal byte sequence"
>>
>>
>>
>> DBF file character encoding is set to WINDOWS-1252 which if I am reading
>> correctly should support Unicode characters.
>>
>>
>>
>> Based on comments posted on the net I also tried setting encoding to
>> “Latin1”
>>
>> Any thoughts on how to correct this problem would be greatly appreciated.
>>
>>
>>
>> I am using PostgreSql version 8.8 and PostGis 1.5.1
>>
>>
>>
>> Bruce
>>
>>
>>
>> This message and any enclosures are intended only for the addressee.  Please
>> notify the sender by email if you are not the intended recipient.  If you
>> are
>> not the intended recipient, you may not use, copy, disclose, or distribute
>> this
>> message or its contents or enclosures to any other person and any such
>> actions
>> may be unlawful.  Ball reserves the right to monitor and review all messages
>> and enclosures sent to or from this email address.
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>



More information about the postgis-users mailing list