I want to convert Shape data with the QGIS browser in the SQLite database . Unfortunately, the umlauts then appear with a mark (see screen shot ) . I do not want to change the UTF-8 encoding for each Layer . Can someone help me ?
If you export the data using
Save As ..., you can change the encoding to
According to my answer for Incorrect display of national characters from Spatialite in QGIS, Windows, there are two ways of loading spatialite data into QGIS, which set the encoding on reading differently. You can try both and see which one works for you.
This bug may be related: http://hub.qgis.org/issues/10944