[Koha-bugs] [Bug 18336] Use utf8mb4 instead of utf8 for MySQL tables, columns, and connections

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

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

M. Tompsett <mtompset at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mtompset at hotmail.com

--- Comment #10 from M. Tompsett <mtompset at hotmail.com> ---
(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.