[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

--- Comment #2 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to David Cook from comment #1)
> biblioitems.url now uses MEDIUMTEXT
> 
> However, I don't think items.uri necessarily need to be the same as
> biblioitems.url.

Since it is variable length, I dont think making the distinction is needed. The
link you gave talks about keeping it under 2048 btw. I would go for MEDIUMTEXT
here too for consistency.

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

Why only ever 1? Our 952$u is derived from 852$u which is a repeatable field.
Unfortunately our editor does not yet support it [1]. But the Koha to MARC
mapping underneath supports url1 | url2 | url3 etc., like in biblioitems.url.


[1] It does not support adding a subfield directly. But if you save url1 | url2
in $u and reopen the item record, the field is cloned for you. Editing and
savin g again is supported now too. Which is something that we wanted to
prevent on bug 21800 but luckily we did not yet so far ;)

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