GeoServer problems with russian

[mihkelo]

Hi,
hopefully You don't mind I write in (bad) english. I'm from Estonia, learned russian over 12 years and unfortunately not speak it at all. Well, let it be...
I hope, that someone have run into weird problems related with russian letters and GeoServer. I tried to set up WMS services with GeoServer on top of database (PostGIS) where all field names and values are in cyrillic. Everything seems to work, but when I try to create CQL filters from OpenLayers in russian, then it do not work.

For example

Код: Выделить всё

CQL_FILTER=myfield='тому'

works well, but

Код: Выделить всё

CQL_FITLER=тому='myvalue'

don't.

WMS gives following error:

Код: Выделить всё

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
  <!DOCTYPE ServiceExceptionReport SYSTEM ...>
    <ServiceExceptionReport version="1.1.1" >
      <ServiceException>Could not parse CQL filter list. Lexical error at line 1, column 1.  Encountered: "\u0442" (1090), after : "" Parsing : ????=1.
      </ServiceException>
    </ServiceExceptionReport>

Also, WFS do not work with filters:

Код: Выделить всё

<ows:ExceptionReport xmlns:ows=...>
  <ows:Exception exceptionCode="NoApplicableCode">
    <ows:ExceptionText>java.lang.RuntimeException: Failed to get property:{http://www.opengis.net/wfs/2.0}boundedBy Failed to get property: {http://www.opengis.net/wfs/2.0}boundedBy java.io.IOException null ERROR: column "    " does not exist Position: 80
    </ows:ExceptionText>
  </ows:Exception>
</ows:ExceptionReport>

Weird is that with combination GeoServer 2.2.2 in Windows, WFS do not work at all with cyrillic fieldnames, but with version 2.1.3 in Debian, WFS works (without filters). Also, If filters are OGC filters (posted xml), it works.

Is anybody run into this behavior? Any help or quidelines are more than appreciated.

Mihkel
GIS developer from Estonia.

[Максим Дубинин]

how about not using fieldnames in cyrillic, this is universally a bad idea

[mihkelo]

Well, I am agree, but it's not up to me. Spatial data comes from client and it is entirely in russian. Also one requirement is filtering from UI, and there would be nice to have field names and values both in cyrillic. Of cource, if there is no other reasonable solution, I need to rename all field names in database. But this will be my last solution.