Bug 18336: Shift *TEXT columns size
authorTomas Cohen Arazi <tomascohen@theke.io>
Fri, 16 Feb 2018 14:25:31 +0000 (11:25 -0300)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 16 Feb 2018 20:53:43 +0000 (17:53 -0300)
commit340042dbaeb12d78aa6b10da9f05fa5ea4060435
tree6a3e3012c9595138569d96b614ccfea6c19f8164
parentf45d606e109ed7367d1f18d4e4919347da40fd10
Bug 18336: Shift *TEXT columns size

Because of the 3-byte vs. 4-byte char size change in utf8mb4, altering a
column's encoding from utf8 into utf8mb4 results in this changes:

TEXT => MEDIUMTEXT
MEDIUMTEXT => LONGTEXT

The column size in the rows (the text itself goes to a separate object
storage) shifts by 1 byte, because all chars are shifted in bytes size
too, so there needs to be room for the byte-count in the column.

This is a debatable change, but the path needs to be included along with
the rest of the patchset for consistency.

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
installer/data/mysql/kohastructure.sql