Low Description
By default, MySQL creates Dbs with case insensitive comparisons (although our documentation specifies that case sensitive comparisons must be used)
We don't check this, which can cause problems if a path is stored in one case and later occurs in a different case.
e.g.:
2009-12-01 20:58:33,242 ERROR [btpool0-310] org.hibernate.util.JDBCExceptionReporter org.hibernate.util.JDBCExceptionReporter-logExceptions - Duplicate entry 'FE-18870-48891' for key 2
We need to check this configuration and report it with a banner (should this be on every page or just the admin page?)
Attachments
Issue Links
- is related to
-
CRUC-3122 Case Sensitivity check acting funny with MySQL using utf8_bin collation
-
- Closed
-
-
FE-3250 DB migration: fix incorrect message "The database is case insensitive. Crucible requires that the database use a case sensitive collation" to reflect the current check: "The database is not Unicode. Crucible requires ..."
- Closed
-
- Closed
