The ArcGIS Enterprise web apps send a non-unicode formated REST API query to an SQL server-based feature service.

Workaround

Alter the collation for a column to make it accent-insensitive (_AI), but this returns extra results.

ALTER TABLE RB.RB_test_1 ALTER COLUMN STR nvarchar(255) COLLATE Latin1_General_100_CI_AI_SC_UTF8

Schritte zur Reproduzierung