[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