Bug report #6772
Categorized Style: if column is "character" and too long in PostGIS then style takes on null value
|Affected QGIS version:||1.8.0||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||not reproducable|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||15923|
On creating a categorized style on a layer coming out of PostGIS, the column I select is of a 'character' datatype and the character length in PosgreSQL is longer than the number of characters in the data. The result is all features take on a style of the null value. If you store varying length characters in the field it has the same effect.
It may not be good practice store data with less characters than the defined character length in a character field however it can happen and it took me sometime work out the problem, so a fix in QGIS would be ideal.