filter whereclause with a Chinese character field

103
2
09-27-2018 06:58 PM
Highlighted
New Contributor II

I would like to get some data from a ArcGIS rest service filtered by the whereclause of queryfilter. It is working that the field name is English but failed with Chinese field name. I also try to plus double quotes(") or square brackets([]) to the Chinese field but is still not working. (ex: "㯗位"='001' or [欄位]='001'). The first syntax got timeout and next got an error message: An invalid SQL statement was used. 

Reply
0 Kudos
2 Replies
Highlighted
Esri Regular Contributor

I've been investigating this issue.  Are you using the Pro SDK (i.e., Table.Search(QueryFilter)) to execute this query, or going directly against the REST endpoint?  What is your underlying database type?

Thanks,

--Rich

Reply
0 Kudos
Highlighted
New Contributor II

Hi Rich Ruh,

I queried the service data by Table.Search method. Our team doubt the issue is caused by the performance weakness of this service with over two millions polygon data. Now we solved this problem by API solution. Thank you for your attention.

Reply
0 Kudos