search

qissue-bot / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
http://qgis.org
GNU General Public License v2.0
0 stars 0 forks source link

Unique value symbology doesn't work in canvas with postgres "character" data type #2473

Open qissue-bot opened 5 years ago

qissue-bot commented 5 years ago

Author Name: Mike Taves (Mike Taves) Original Redmine Issue: 2486, https://issues.qgis.org/issues/2486

If a unique value symbology is applied to a PostGIS layer with a data type "character", it can be formatted normally in the layer properties dialog with expected results in the "Layers" pane. However, the lines are not formatted in the map canvas as expected, as all lines use the "default" (blank) classification.

A possible cause of the problem is that the data type "character" will pad spaces to the specified width, for example "food" stored in character(5) will actually be "food ", having a trailing space to fit 5 characters.

As a workaround, change the postgres data type in problem columns to "character varying", if possible.

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: springmeyer - (springmeyer -) Original Date: 2010-03-03T09:48:30.000Z

ya, generally you don't want to use 'character' type, but when you do QGIS likely should not strip the padded whitespace.

I've not dug into this in a while, but noticed the issue via the Quantumnik plugin. Details here:

http://trac.mapnik.org/ticket/369

qissue-bot commented 5 years ago

Original Redmine Comment Author Name: Jürgen Fischer (Jürgen Fischer) Original Date: 2016-02-25T07:56:12.000Z

not reproducable anymore