[gdal-dev] MSSQL Spatial and UTF-8

[Jukka Rahkonen]

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-