Hi Magnus I use datasets in the Icelandic language (lots of accented and strange characters) all the time and their encoding is usually either ISO-8859-1 or UTF-8. When I import into PostGIS, I usually use the import tools provided in the DB Manager. In my experience, the characters are transferred correctly if I set the encoding correctly for the layer beforehand. In other words, if they show up right in the attribute table in QGIS, the will also be right when they have landed in PostGIS. My only gripe is that I can't find a way to set a default character encoding for new layers, the system encoding seems to be the hard-wired default, which for me is ISO-8859-1 but I would like to set the default to UTF-8. Does anyone know a way to accomplish this?
Arni Árni Geirsson *Alta ehf* // +354 582 5000 // +354 897 9549 On 6 March 2017 at 21:34, johnrobot <johnro...@gmail.com> wrote: > Hi > I use "Import into PostGIS" in a model to write a road network to PostGIS. > However, the Swedish characters å/ä/ö are replaced with "�" in the > attributes. The encoding in the tool is set to UTF-8. Any suggestions on > how > to handle this? Windows 10, QGIS 2.18.4, 64 bit. > > Regards, > > Magnus > > > > -- > View this message in context: http://osgeo-org.1560.x6. > nabble.com/Processing-Encoding-problem-with-Import- > into-PostGIS-tp5311044.html > Sent from the QGIS - User mailing list archive at Nabble.com. > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
