laptop and a wrench

Bug

The Select By Attributes tool does not recognize the Japanese characters in the attribute table.

Last Published: July 6, 2020 ArcGIS Pro
Bug ID Number BUG-000117598
SubmittedOctober 22, 2018
Last ModifiedNovember 20, 2024
Applies toArcGIS Pro
Version found2.2
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusWill Not Be Addressed

Additional Information

This is by design for the SQL server. The workaround listed in the issue is how one should query Unicode. Refer to this support help documentation in the following link for more information, https://support.esri.com/en/technical-article/000009193

Workaround

  1. In ArcGIS Pro, click the Select By Attribute tool.
  2. Click Add Clause.
  3. Select the field name.
  4. For the Value parameter, press N. The tool automatically selects the Japanese word.
Video demonstrating the workaround: https://www.screencast.com/t/C7XiYMtV 

Steps to Reproduce

Bug ID: BUG-000117598

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options