Gunter Becker <gunter.becker <at> csogis.de> writes: > > Hi, > > I'm trying to import a shapefile via ogr2ogr into a SQL Server 2008 DB. When > looking at the created table I realised that some columns have some ugly > columnnames. Same to the strings in the data of this table. The problem is > caused by some special characters (german umlauts) in the dataset. > > Using ogr2ogr with other drivers (ex. SQLite, PostGIS) to import this > shapefile works as expected so that I think it is a problem with the "MSSQL > Spatial"-driver. > > Is there any driver related setting I can make to force UTF-8 import into > SQL Server?
You can try if setting SHAPE_ENCODING environment variable to suit your shapefile before running ogr2ogr helps. It did help me couple of days ago with Spatialite. -Jukka Rahkonen- _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
