[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

Marcel de Rooy <m.de.rooy at rijksmuseum.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |m.de.rooy at rijksmuseum.nl

--- Comment #4 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
ALTER TABLE authorised_values MODIFY COLUMN authorised_value varchar(255)

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.

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