shp2pgsql field length problem

[agnar]

Bug found on shp2pgsql (5098 2010-01-04). My version is recently installed on a Debian server using apt. It might not be the newest version, but the bug may still exist?

My shape file contained a field of type text(20). The corresponding sql-file contained a corresponding declaration of varying(20).

Subsequent inserts of records having exact 20 characters for that field failed. Editing the sql file to varying(21) resolved the problem.

But I would expect shp2pgsql to handle this eventuality.

[robe]

I've seen this problem before in PostgreSQL. Usually has to do with encoding.

What encoding did you assume for the file and what is the encoding of your dataase?

Also what version of PostgreSQL are you running?

[pramsey]

Attach a test file to the ticket if you require a fix.

[pramsey]

I'm going to guess UTF-8 data, so that the high-bit characters take 2bytes, so sometimes a 20-long string ends up as 21. Without pre-scanning the whole file, it's not really fixable. I'd like to see a test file.