[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
Mon Jun 19 20:40:42 CEST 2023


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

--- Comment #8 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(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.

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


More information about the Koha-bugs mailing list