This is something that can be fixed by binding the UTF8 strings as unicode when passing to the ODBC driver. Going to provide a fix for this issue in the MSSQL driver soon.
Best regards, Tamas 2014-09-27 17:45 GMT+02:00 Vladan Divljak <[email protected]>: > Hi, > > I want migrate data between PostGIS enabled Postgres database and SQL > Server spatial database. ogr2ogr seems like easiest possible way, but there > is a catch with this ticket: http://trac.osgeo.org/gdal/ticket/5239 > > I tried it nonetheless, but as expected Postgres tables with UTF-8 strings > show garbage in SQL Server. > > I don't see any switch in org2ogr to be able to dump sql queries that > ogr2ogr executes in migration process. Is there any? That way I can > search/replace to get correct sql queries for the task. > > > Thanks, > Vladan > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
