This question already has an answer here:
I'm testing this command to migrate GeoJSON data to MSSQL table:
ogr2ogr -f MSSQLSpatial "MSSQL:server=.\SQLEXPRESS;database=geodb;trusted_connection=yes" test.json -nln test
It works beautifully, but if json data contains other characters then ASCII I get garbage in MSSQL table for that field:
Json file is UTF-8 encoded without BOM header.
I tried appending
-lco ENCODING=UTF-8 parameter to
ogr2ogr command, but that didn't help.
So I wonder if anyone knows how to set sqlserver and ogr2ogr to communicate Unicode?