You removed the ${ } that is used t o mark a CQL filter.
Can I ask if using this works:
filter: ${Rank LIKE 'خیلی زیاد'}
ECQL should be fine using any Unicode characters, no need to use a N string
prefix (this is our own little language and not SQL).
--
Jody Garnett
On Tue, 27 Aug 2019 at 06:40, alich65 <[email protected]> wrote:
> 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
>
_______________________________________________
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
