Select to view content in your preferred language

filter whereclause with a Chinese character field

412
2
09-27-2018 06:58 PM
重溪陳
Emerging Contributor

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
重溪陳
Emerging Contributor

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