https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39618
--- Comment #24 from David Cook <dc...@prosentient.com.au> --- (In reply to Katrin Fischer from comment #23) > Follow-up pushed to main. > > @David: can you explain about your choice of 768? It's two-fold. First, middle_name and other longtext column indexes are configured the same way. Second, it's what MySQL says to do: "For InnoDB tables that use COMPRESSED or DYNAMIC row format, index key prefixes longer than 767 bytes (up to 3072 bytes) are permitted. Tables created with these row formats enable you to index a maximum of 1024 or 768 characters for utf8mb3 or utf8mb4 columns, respectively." 768 characters at 4 bytes each = 3072 total bytes https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://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/
