laptop and a wrench

Bug

Queries with Czech or Slovak characters do not work on services when the data is stored in an SQL server database.

ArcGIS GIS Server
Bug-ID-Nummer BUG-000162080
EingereichtOctober 13, 2023
Zuletzt geändertJune 5, 2024
Gilt fürArcGIS GIS Server
Gefunden in Version11.1
BetriebssystemWindows Server
Betriebssystemversion2019 64 Bit
StatusAs Designed

Zusätzliche Informationen

The N prefix must be used while querying using a Unicode string against SQL Server. For reference, refer to https://support.esri.com/en-us/knowledge-base/problem-attribute-queries-using-unicode-strings-do-not-000009193.

Workaround

A possible workaround is to include the N prefix before the string to query.

Not working:

Field='<SearchText>'

Add N before the string and it supposedly works:

Field=N'<SearchText>'

Alternatively, instead of referenced publishing, publish with CopyOption, when suitable.

Schritte zur Reproduzierung

Bug-ID: BUG-000162080

Software:

  • ArcGIS GIS Server

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln