Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm trying to join a .dbf I made in LibreOffice with a shapefile. The .dbf contains ~10 columns, three of which have a large amount of text (~100 words).

When I import the .dbf into QGIS, all columns appear correctly except for the three with the lengthy text, which instead appear with number values: 0000000001, 0000000003, 0000000005, 0000000007....

Any thoughts on why QGIS is not reading these values correctly?

share|improve this question
add comment

2 Answers 2

For the text datatype, length is limited by the dbf format to 65534 characters. Exceeding this would cause QGIS to react strangely. Check this first. In ArcGis (sorry, don't know about QGIS), the text field length is typically max 254.

share|improve this answer
add comment

Michael Marketa is right: quote from wikipedia: A second filetype is the .dbt file format for memo fields. While character fields are limited to 254 characters each, a memo field is a 10-byte pointer into a .dbt file which can include a much larger text field. But: the shapefile-format and therefore qgis cant use this dbt-files! BTW: When you try to export a a file to dbf in the actual libreoffice and a text record contains more chars than 254 you get an error message.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.