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.
