[Koha-bugs] [Bug 31716] Enlarge the size of the authorised_value column in authorised_values

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #9 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to Nick Clemens from comment #8)
> (In reply to Marcel de Rooy from comment #4)
> > You go from 80 to 255. At some point that is too low again. We should imo go
> > to a TEXT type: A TEXT column with a maximum length of 65,535 (216 - 1)
> > characters.
> > One point: VARCHAR columns can be fully indexed. TEXT columns can only be
> > indexed over a specified length.
> 
> Some versions of MySQL/Maria allow varchar up to 65535 - so we can increase
> in future as needed - this was the largest push without more work and
> sufficient for current needs

URLs could be up to 2048 chars? Note that addressing the authorized values
table is only half of the work. The receiving column should be able to store it
too. But you know :)

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