I have a Sql Server Store in Geoserver. This my ysld file:
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 but Geoserver can not
handle that. Please attention to blow images:
<http://osgeo-org.1560.x6.nabble.com/file/t381194/11.png>
<http://osgeo-org.1560.x6.nabble.com/file/t381194/22.png>
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
