laptop and a wrench

Bug

Letter casing is ignored when executing an SQL check through Batch Validate when the data is in a personal geodatabase.

Last Published: April 18, 2016 No Product Found
Bug ID Number BUG-000080932
SubmittedSeptember 3, 2014
Last ModifiedSeptember 22, 2022
SeverityMedium
Applies toNo Product Found
Version foundNo Version Found
StatusKnown Limit

Additional Information

This is expected behavior. As stated in the help topic, 'Building a query expression' - Strings in expressions are case sensitive except when querying personal geodatabase feature classes and tables. To make a case-insensitive search in other data formats, use an SQL function to convert all values to the same case. For file-based data sources like file geodatabases or shapefiles, use either the UPPER or LOWER function.

Steps to Reproduce

Bug ID: BUG-000080932

Software:

  • No Product Found

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback