Using QGIS 2.14.0, Windows 10, when I use 'Save As' to save a polygon shapefile as a Spatialite layer (all options left as default), all of the input integer fields are incorrectly output as text string fields. This sure seems like an error to me. I reviewed the Spatialite web site, but didn't see anything. Am I doing something wrong?

1 Answer 1


If you have null values in the integer fields the issue may be due to a GDAL bug https://trac.osgeo.org/gdal/ticket/6351 which is fixed but not included in released GDAL 1.11.x or 2.0.x versions. Read also https://trac.osgeo.org/gdal/ticket/6427 for further details.

If you do not have null values in your integer fields the problem must be somewhere else. In that case add a link to a small zipped shapefile which can be used for reproducing the error.

  • well, I updated to 2.14.1 (via the full OSGEO4W64 install), and I cannot recreate the problem, so I assume that the GDAL bug that you indicate must have been incorporated into this latest QGIS release. Sorry, but I don't have the programming skill to understand the links that you provide. Thanks for the help.
    – Stu Smith
    Apr 10, 2016 at 5:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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