query feature service from SQL server

SPNIOrganization — Thu, 29 Nov 2018 15:25:55 GMT

Hi!

I have a Map service that it's source is a feature from SDE (sql server 12).

published using arcgis for server 10.5.1.

when I'm using query through the rest, on a string field, I'm getting nothing. No records found.

the field is SiteName and it has Hebrew names. for example - "ירדן"

the syntax I used is: SiteName LIKE '%ירדן%'

I suspected that the query will work if the source of the service will be a feature class in a regular GDB, not in SDE.

and I was right!

in this service, the query on the same field is working fine: Layer: כיוון המסלול (ID: 0)

the syntax I used is: SiteName LIKE '%ירדן%'

So, what can be the problem in my SDE that Prevents the query to search for the strings?

Thanks,

Dikla.

topic query feature service from SQL server in ArcGIS Online Questions