Case sensitivity in vendor databases

Vendor databases have different settings for case sensitivity. This setting must be consistent across databases if either of these conditions are true:

A database is moved from one vendor to a different vendor.

A HCL Compass MultiSite environment uses multiple synchronized databases with different vendor databases.


Database vendor	Possible settings	Comments
Microsoft™ SQL Server	Not case-sensitive, Case-sensitive	Case sensitivity affects database object names and data. It can be set by using the installation time option or the database creation time option.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box. Note: To report a problem or question about the product software, do not use this form. Instead, go to the HCL Software Support site.