Troubles on Query With ArcGIS Server 10.21

1489
0
06-06-2014 11:42 AM
jonataspovoas
New Contributor III
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.
0 Kudos
0 Replies