[QGIS-trac] [Quantum GIS] #2486: Unique value symbology doesn't work in canvas with postgres "character" data type

[Quantum GIS]

#2486: Unique value symbology doesn't work in canvas with postgres "character"
data type
------------------------------------------------+---------------------------
   Reporter:  mwtoews                           |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.5.0
  Component:  Symbology                         |            Version:  HEAD         
   Keywords:                                    |   Platform_version:               
   Platform:  Windows                           |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 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.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2486>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats