[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

--- Comment #11 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
(In reply to M. Tompsett from comment #10)
> (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

A lot of *indexes* are shrunk from 255 to 191. This has the impact of making
searches on things longer than 191 chars require some more CPU usage
(probably). But no data is shrunk in most of the changes.

The tags_* tables get the 'term' column shrunk, because I didn't manage to fix
it other way. It seems a safe one, though. Tags are usually a single word...

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