[Koha-bugs] [Bug 5377] New: Database fields too small for multiple ISBN and ISSN

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5377

           Summary: Database fields too small for multiple ISBN and ISSN
 Change sponsored?: ---
           Product: Koha
           Version: rel_3_4
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: major
          Priority: P5
         Component: Database
        AssignedTo: gmcharlt at gmail.com
        ReportedBy: fridolyn.somers at gmail.com
         QAContact: koha-bugs at lists.koha-community.org
   Estimated Hours: 0.0


Hie,

I noticed a wrong behavior in "koha to MARC mapping".

Using a mapping for ISBN and ISSN fields, I noticed that fields "isbn" and
"issn" where truncated in "biblioitems" table when using multiple values.
With multiple values, ISBN and ISSN are separated by a " | ".

In fact, "isbn" field is a VARCHAR(30)
     and "issn" field is a VARCHAR(9).

This is far to small. I propose a VARCHAR(255).

Regards,

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.