UnicodeEncodeError when trying to create new layer with spatial index in DB manager

[qgib]

Author Name: Johannes Kroeger (Johannes Kroeger)
Original Redmine Issue: 17418
Affected QGIS version: 2.18.14
Redmine category:db_manager

---

I tried to upload a layer to PostGIS in the DB Manager and got the following error:

UnicodeEncodeError: 'ascii' codec can't encode character u'\xe4' in position 5: ordinal not in range(128) 
Traceback (most recent call last):
  File "/usr/share/qgis/python/plugins/db_manager/dlg_import_vector.py", line 375, in accept
    self.db.connector.createSpatialIndex((schema, table), geom)
  File "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/connector.py", line 966, in createSpatialIndex
    idx_name = self.quoteId(u"sidx_%s_%s" % (tablename, geom_column))
  File "/usr/share/qgis/python/plugins/db_manager/db_plugins/connector.py", line 193, in quoteId
    identifier) if identifier is not None else str()  # make sure it's python unicode string
UnicodeEncodeError: 'ascii' codec can't encode character u'\xe4' in position 5: ordinal not in range(128)


Python version: 2.7.14 (default, Sep 20 2017, 01:25:59) [GCC 7.2.0] 
QGIS version: 2.18.13 Las Palmas, exported

To reproduce:

Try to add a layer to PostGIS via DB Manager where the "Table" name has a non-ascii character (like "ä") and tick the "Create spatial index" option.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Works as expected on master.

---

• version was changed from 2.18.13 to 2.18.14

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Alexander Bruy (@alexbruy)

---

• resolution was changed from to no timely feedback
• status_id was changed from Feedback to Closed

[qgib]

Author Name: Johannes Kroeger (Johannes Kroeger)

---

Confirming it works fine in QGIS 3.4/3.5.

---

• resolution was changed from no timely feedback to fixed/implemented