If your database utilizes a case-insensitive collation, as commonly found in databases such as MySQL and MSSQL, by default, it is advisable to transition to a case-sensitive collation, aligning with the case-sensitive nature of Artifactory.
To implement this change across existing tables in the database, each table should undergo alteration using commands similar to the examples below:
To implement this change across existing tables in the database, each table should undergo alteration using commands similar to the examples below:
ALTER TABLE access_configs CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; … ALTER TABLE nodes CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; … ALTER TABLE watches CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;Below is an explanation of the issue and how to address it. The demonstration provided here is based on MySQL.