Bug
Queries with Czech or Slovak characters do not work on services when the data is stored in an SQL server database.
| Bug ID Number | BUG-000162080 |
|---|---|
| Submitted | October 13, 2023 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS GIS Server |
| Version found | 11.1 |
| Operating System | Windows Server |
| Operating System Version | 2019 64 Bit |
| Status | As Designed |
Additional Information
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.
Steps to Reproduce
Bug ID: BUG-000162080
Software:
- ArcGIS GIS Server
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App