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

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Feb 5 19:55:18 CET 2018


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

--- Comment #46 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
(In reply to Jonathan Druart from comment #45)
> This is certainly not expected:
> 
> Fresh install (with and without the patches):
> | biblio | CREATE TABLE `biblio` (
>   `biblionumber` int(11) NOT NULL AUTO_INCREMENT,
>   `frameworkcode` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
>   `author` mediumtext COLLATE utf8_unicode_ci,
>   `title` mediumtext COLLATE utf8_unicode_ci,
>   `unititle` mediumtext COLLATE utf8_unicode_ci,
>   `notes` mediumtext COLLATE utf8_unicode_ci,
> 
> Fresh master intall + upgrade:
> | biblio | CREATE TABLE `biblio` (
>   `biblionumber` int(11) NOT NULL AUTO_INCREMENT,
>   `frameworkcode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
>   `author` longtext COLLATE utf8mb4_unicode_ci,
>   `title` longtext COLLATE utf8mb4_unicode_ci,
>   `unititle` longtext COLLATE utf8mb4_unicode_ci,
>   `notes` longtext COLLATE utf8mb4_unicode_ci,

It is interesting that the atomicupdate DOESN'T touch the biblio table besides
changing the collation and encoding!

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


More information about the Koha-bugs mailing list