Case-sensitive comparisons
Published 05 June 2013
By default, columns inherit the collation of the database. If you are working with case-insensitive databases, you can run a case-sensitive comparison by selecting the project configuration option Force binary collation (case-sensitive). The setting applies to all columns that contain string data. To perform a case-sensitive comparison, SQL Data Compare uses the Latin1_General_BIN collation.
For example, if you compare Widget and widget, when the project option is not selected, SQL Data Compare considers the data to be identical. When the option is selected, SQL Data Compare identifies the case difference.
If you want to compare objects whose names differ only by their case, such as table names or column names, ensure the Ignore case of object names option is selected.
This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved
