[Koha-bugs] [Bug 34065] New: Remove unnecessary column-level collation settings for upgraded databases

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34065

            Bug ID: 34065
           Summary: Remove unnecessary column-level collation settings for
                    upgraded databases
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: P5 - low
         Component: Database
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: dcook at prosentient.com.au
        QA Contact: testopia at bugs.koha-community.org

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.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.