[Koha-bugs] [Bug 20882] URI column in the items table is limited to 255 characters

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

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

David Cook <dcook at prosentient.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dcook at prosentient.com.au

--- Comment #1 from David Cook <dcook at prosentient.com.au> ---
biblioitems.url now uses MEDIUMTEXT

However, I don't think items.uri necessarily need to be the same as
biblioitems.url.

With biblioitems.url, multiple URLs are concatenated in the same field, but
items.uri should only ever store 1 URL.

This link presents a number of different length limits for 1 URL:
https://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers

The largest CloudFlare seems to support is 32Kb and a TEXT field can store
64KB. 

I suppose using MEDIUMTEXT could provide some future proofing, but TEXT is
probably good enough for items.uri.

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