[Koha-bugs] [Bug 34029] Import breaks when data exceeds size of mapped database columns

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Jun 20 13:16:21 CEST 2023


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

--- Comment #9 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to Katrin Fischer from comment #8)
> (In reply to Marcel de Rooy from comment #7)
> > (In reply to Katrin Fischer from comment #3)
> > > Bug 28328 increased several columns to longtext, biblio is almost completely
> > > longtext, so I suggest to do the same for the remaining varchars in
> > > biblioitems:
> > > 
> > > * place
> > > * publishercode
> > > * illus
> > > * pages
> > > * size
> > 
> > Might not really matter, but LONGTEXT (4G) seems to be absolute overkill for
> > these five fields. Tinytext might be just too small.
> 
> Mostly picked longtext because the majority of datatypes is already longtext
> if you look at biblio and biblioitems. What do you suggest? We also have a
> fair bit of mediumtext.

Comment2

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


More information about the Koha-bugs mailing list