topic Troubles on Query With ArcGIS Server 10.21 in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/troubles-on-query-with-arcgis-server-10-21/m-p/102171#M459 <HTML><HEAD></HEAD><BODY><SPAN>I'm migrating my services from ArcGIS Server 10.05 to 10.21, and I'm having trouble with a few queries that I used to do.</SPAN><BR /><BR /><SPAN>On the service rest I use the following input on the where parameter:</SPAN><BR /><BR /><SPAN>UPPER(translate(NOME, 'âàãáÁ??????éê????íÍóôõ??????üú??????ç','AAAAAAAAEEEEIIOOOOOOUUUUCC')) like UPPER('%convenc%') AND CODIGO_MUNICIPIO =2740</SPAN><BR /><BR /><SPAN>While testing this code at the service rest page, if I remove the translate function it works. The problem is that I must use it to change accentued characters into non-accentued.</SPAN></BODY></HTML> Fri, 06 Jun 2014 18:42:55 GMT jonataspovoas 2014-06-06T18:42:55Z Troubles on Query With ArcGIS Server 10.21 https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/troubles-on-query-with-arcgis-server-10-21/m-p/102171#M459 <HTML><HEAD></HEAD><BODY><SPAN>I'm migrating my services from ArcGIS Server 10.05 to 10.21, and I'm having trouble with a few queries that I used to do.</SPAN><BR /><BR /><SPAN>On the service rest I use the following input on the where parameter:</SPAN><BR /><BR /><SPAN>UPPER(translate(NOME, 'âàãáÁ??????éê????íÍóôõ??????üú??????ç','AAAAAAAAEEEEIIOOOOOOUUUUCC')) like UPPER('%convenc%') AND CODIGO_MUNICIPIO =2740</SPAN><BR /><BR /><SPAN>While testing this code at the service rest page, if I remove the translate function it works. The problem is that I must use it to change accentued characters into non-accentued.</SPAN></BODY></HTML> Fri, 06 Jun 2014 18:42:55 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/troubles-on-query-with-arcgis-server-10-21/m-p/102171#M459 jonataspovoas 2014-06-06T18:42:55Z