[Koha] Barcode length

Chris Cormack chrisc at catalyst.net.nz
Tue Jan 10 10:25:29 NZDT 2017


* Pedro Amorim (pjamorim91 at gmail.com) wrote:
>Hello everyone,
>
>I have a question regarding barcode length in Koha.
>I'm importing a new biblio database and some barcodes have length of 26 or
>28 and so on.
>
>Koha's database schema limits the barcode field in the items table to
>varchar(20).
>
>My question is:
>Is it okay to manually alter this field length? As so:
>
>*ALTER TABLE items MODIFY barcode VARCHAR(40);*

You need to modify the deleteditems table to match too
>
>What sort of problems can this cause in the future? Do I have to apply this
>change everytime I update Koha to a newer version?

You shouldn't only if you drop and recreate your database.

But please do this on a test system first, before you try it in 
production

Chris
>
>Thanks a bunch,
>
>Pedro Amorim
>_______________________________________________
>Koha mailing list  http://koha-community.org
>Koha at lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <https://lists.katipo.co.nz/pipermail/koha/attachments/20170110/b0610c28/attachment.sig>


More information about the Koha mailing list