Bug 34065

Summary: Remove unnecessary column-level collation settings for upgraded databases
Product: Koha Reporter: David Cook <dcook>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: minor    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description David Cook 2023-06-20 06:39:31 UTC
There is a discrepancy on column collation between kohastructure.sql and upgraded databases.

One example is the "localization" table. Upgraded databases will have "utf8_unicode_ci" set for column collation and table collation. 

However, kohastructure.sql only has it at the table level.

If you're using an audit script like in bug 34064, this difference will show up. While it's a minor difference, it's a noisy difference and a difference nonetheless.