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.
this is the rest URL: Layer: כיוון המסלול (ID: 2)
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.