QGIS – How to Display Special German Characters on a Map

databaseencodingqgisqgis-pluginsshapefile

I have a shapefile with names for Regions. These don't seem to contain special characters "Ä", "Ü", "Ö", "ß" but ugly hieroglyphs.

What can I do to display them correctly. If I import the shape as UTF-8 it doesn't work.

The names are in a dbase table. So is it possible to save a dbase table in UTF-8 or is there a different way of dealing with it?

Best Answer

enter image description here

try opening the dbase-file with libreoffice (or openoffice) and try different encodings, if utf-8 doesnot work try iso-8859-1 and look if the chars öäüß are displayed correctly

Related Solutions

QGIS – How to Fix Shapefile’s Character Encoding Using ogr2ogr on the Command Line

Quoting from the GDAL documentation for the Esri Shapefile driver:

An attempt is made to read the LDID/codepage setting from the .dbf file and use it to translate string fields to UTF-8 on read, and back when writing. LDID "87 / 0x57" is treated as ISO8859_1 which may not be appropriate. The SHAPE_ENCODING configuration option may be used to override the encoding interpretation of the shapefile with any encoding supported by CPLRecode or to "" to avoid any recoding. (Recoding support is new for GDAL/OGR 1.9.0)

Depending on which GDAL/OGR version you are using, ogr2ogr may be trying to translate your data to UTF-8 or not doing nothing at all.

So you would do either:

ogr2ogr --config SHAPE_ENCODING "UTF-8" -f "MySql" MySql:"basemap,host=127.0.0.1,user=myUser,password=myPass,port=3306" -lco engine=MYISAM "C:/path/to/data/tl_2012_us_county.shp" -nln county -nlt "geometry" -s_srs EPSG:4269 -t_srs EPSG:3857

ogr2ogr --config SHAPE_ENCODING "" -f "MySql" MySql:"basemap,host=127.0.0.1,user=myUser,password=myPass,port=3306" -lco engine=MYISAM "C:/path/to/data/tl_2012_us_county.shp" -nln county -nlt "geometry" -s_srs EPSG:4269 -t_srs EPSG:3857

Finally, check that your MySQL database is using UTF-8 and not Latin-1.

[GIS] Greek characters are not displayed correctly in QGIS on Windows 8

Dkar did you check your Windows encoding ? (CMD>>chcp). You wrote that on Win7 its ok, check this command on booth systems and compare results.

Best Answer

Related Solutions

QGIS – How to Fix Shapefile’s Character Encoding Using ogr2ogr on the Command Line

[GIS] Greek characters are not displayed correctly in QGIS on Windows 8

Related Question