filter whereclause with a Chinese character field

172
2
09-27-2018 06:58 PM
重溪陳
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. 

0 Kudos
2 Replies
RichRuh
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

0 Kudos
重溪陳
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.

0 Kudos