I'm trying to dump some tables out of MS SQL Server 2000 using a vrt file. The sql query includes a text field that could contain a large amount of characters.
Here's my VRT file: <OGRVRTDataSource> <OGRVRTLayer name="Layer1"> <SrcDataSource>MyDSN</SrcDataSource> <SrcSQL>EXEC MySP</SrcSQL> <FID>ID</FID> <GeometryType>wkbPoint</GeometryType> <LayerSRS>WGS84</LayerSRS> <GeometryField encoding="PointFromColumns" y="Latitude" x="Longitude"/> </OGRVRTLayer> </OGRVRTDataSource> I'm using org2ogr to produce a shapefile and it's all working fine. However, when I open the DBF file in Excel I see that the text field has been truncated at exactly 80 characters. I'm guessing that it's doing this by default because no explicit value has been set for the text field length. How can I specify a length for a text (string) field for my shp file when dumping out via ogr2ogr and a vrt file as above? Cheers, Steve
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users