I may be wrong, so anyone out there with more knowledge please correct, but I don't think you can use spaces in the ccode so changing the length wont help. Can't you do a simple find and replace? Make your current collect code the description and make up a new shorter ccode for the underlying code. For most of the Koha web pages its the description that shows not the code. Susan Bennett ILS System Administrator Geauga County Public Library 440 286-6811 x 125 440 286-7419 FAX On Mon, Nov 29, 2010 at 3:26 PM, Paul <paul.a@aandc.org> wrote:
Problem: the CCODE in the Koha SQL database is limited to 10 characters only. We have (transferring our data from spreadsheets) dozens of categories that exceed this limit e.g. "marine biology", "yacht cruising", etc.
Does anyone know of a quick way to modify the field length in SQL "on the fly"?
Many thanks - the alternative is to manually correct tens of thousands of entries spread across hundreds of spreadsheets.
Paul
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha