jpovoas

Troubles on Query With ArcGIS Server 10.21

Discussion created by jpovoas on Jun 6, 2014
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.

On the service rest I use the following input on the where parameter:

UPPER(translate(NOME, 'âàãáÁ??????éê????íÍóôõ??????üú??????ç','AAAAAAAAEEEEIIOOOOOOUUUUCC')) like UPPER('%convenc%') AND CODIGO_MUNICIPIO =2740

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.

Outcomes