https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18336
M. Tompsett <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #10 from M. Tompsett <[email protected]> --- (In reply to M. Tompsett from comment #9) > Why did the size change from 255 to 191? After a conversation on IRC with tcohen: A lot of fields are shrunk from 255 to 191. This is because index size for VARCHAR on InnoDB has a max size, in bytes, of 767 bytes (or similar) and utf8 uses 3 bytes for each char, and utf8mb4, 4. 767/3 > 255. but 767/4 > 191. https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-conversion.html Gain functionality (necessary for true unicode), lose space (not an issue yet). -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
