Bug report #5269

New fields created by "table join" are limited to 80 characters when it should be 255

Added by Filipe Dias over 7 years ago. Updated almost 7 years ago.

Status:Closed
Priority:High
Assignee:-
Category:Vectors
Affected QGIS version:1.8.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:fixed
Crashes QGIS or corrupts data:No Copied to github as #:14996

Description

I tried to join a field that had cells with up to 220 characters to a shapefile. However when I saved the new shapefile, I saw that it was only showing the first 80 characters of field. QGIS is cutting the fields with a 80 characters threshold.

sample.zip (40.1 KB) Filipe Dias, 2012-10-05 10:49 AM

Associated revisions

History

#1 Updated by Giovanni Manghi over 7 years ago

  • Operating System deleted (Windows 7)
  • Target version set to 35

Confirmed (on Linux). Joined text field (tested with a csv) are truncated at 80 chars when (re)saving the shapefile.

#2 Updated by Giovanni Manghi over 7 years ago

  • Target version changed from 35 to Version 1.8.0

#3 Updated by Giovanni Manghi over 7 years ago

  • Priority changed from High to Normal

#4 Updated by Filipe Dias about 7 years ago

  • Priority changed from Normal to High
  • Affected QGIS version changed from master to 1.8.0

This bug remains in QGIS 1.8 and think it's urgent to fix it.

#5 Updated by Paolo Cavallini about 7 years ago

  • Target version changed from Version 1.8.0 to Version 2.0.0

#6 Updated by Alexander Bruy almost 7 years ago

  • Status changed from Open to Feedback

Seems already fixed in master. Please test and close.

#7 Updated by Filipe Dias almost 7 years ago

No, it's still there (QGIS Master downloaded today, Windows 7). It joins correctly but when I save it, the new shapefile only has the first 80 characters of each line.

#8 Updated by Alexander Bruy almost 7 years ago

Works fine here, field with length 193 saved correctly. Can you provide sample data?

#9 Updated by Filipe Dias almost 7 years ago

Sample data attached.

#10 Updated by Alexander Bruy almost 7 years ago

Ah, you use CSV table for joined data... As workaround you can specify length and type for each CSV field using CSVT file as described here. Also you can use more powerful and flexible VRT format

#11 Updated by Alexander Bruy almost 7 years ago

  • Status changed from Feedback to Closed

#12 Updated by Alexander Bruy almost 7 years ago

  • Resolution set to fixed

#13 Updated by Filipe Dias almost 7 years ago

Thanks!

Also available in: Atom PDF