Friday, 11 March 2016

postgis - Geoserver WMS and filtering tables with cyrillic column names


I try to serve PostGIS tables with Geoserver WMS (both 2.1 and 2.2). Some column names are in cyrillic.


Problem is - service fails, when I try to filter by those cyrillic columns (both with CQL and regular, XML-based filters). For example:


FILTER=Магазин1

or


CQL_FILTER=Магазин=10

As result, I get




Rendering process failed
Property '??????' could not be found in magasiin


or



Could not parse CQL filter list. Lexical error at line 1, column 1.
Encountered: "\u0430" (1072), after : "" Parsing : ??????=10.



I can't find clear answer from Google. Closest posting is http://jira.codehaus.org/browse/GEOS-4177 that claims, it's bug and it's fixed, but apparently it's not working in my case.


When I get confirmation, it's problem of Geoserver, then onliest solution seems to renaming of those columns.


Also, WFS service seems to fail always (despite of filtering), when at least on column name is in cyrillic.




No comments:

Post a Comment