[Geoserver-devel] [JIRA] (GEOS-9310) Getting error in ysld and css style in GeoServer

GeoServer GeoServer Developer
1

Ali ch65 created an issue

GeoServer / BugGEOS-9310

Getting error in ysld and css style in GeoServer

Issue Type:

BugBug

Affects Versions:

2.14.1

Assignee:

Unassigned

Attachments:

11.PNG, 22.PNG, shapefile.zip

Created:

27/Aug/19 10:38 AM

Environment:

operating system: windows 10
Sql Server Enterprise 2017
Sql Server Collation: Persian_100_CI_AI
geoserver 2.14.1
encoding: UTF-8
I changed java machine unicode to UTF-8(image attached):
Windows Environment Variables >> JAVA_TOOL_OPTIONS : -Dfile.encoding=UTF8

Priority:

HighestHighest

Reporter:

Ali ch65

I have a Sql Server Store in Geoserver. This is my ysld file(I test this scenario with CSS style but it is not working):

title: ‘YSLD Cook Book: Attribute-based polygon’
feature-styles:

  • name: name
    rules:

  • name: empty
    title: empty
    filter: $ {Rank = ‘’}

    symbolizers:

  • polygon:
    fill-color: ‘#66FF66’

  • name: title2
    title: title2
    filter: Rank LIKE N’خیلی زیاد’
    symbolizers:

  • polygon:
    fill-color: ‘#33CC33’

  • name: title3
    title: title3
    filter: $ {Rank LIKE N’زیاد’}

    symbolizers:

  • polygon:
    fill-color: ‘#009900’

  • name: title4
    title: title4
    filter: $ {Rank = N’متوسط’}

    symbolizers:

  • polygon:
    fill-color: ‘#009900’

I get this error: “Error parsing filter” because added “N” prefix to filter. I think that is a bug in GeoServer or SQL Server plugin. Sql Server require to this prefix for execute query on NVARCHAR columns that contains Persian characters but Geoserver can not handle that. When I test top ysld file with Geoserver Shapefile Store it is working fine because problem is with Sql Server.
See attach images:

Add Comment

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100107-sha1:7d9baab)

Atlassian logo