* Pedro Amorim (pjamorim91@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@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