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.<br>
<br clear="all">Susan Bennett<br>ILS System Administrator<br>Geauga County Public Library<br>440 286-6811 x 125<br>440 286-7419 FAX<br>
<br><br><div class="gmail_quote">On Mon, Nov 29, 2010 at 3:26 PM, Paul <span dir="ltr"><<a href="mailto:paul.a@aandc.org">paul.a@aandc.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Problem: the CCODE in the Koha SQL database is limited to 10 characters<br>
only. We have (transferring our data from spreadsheets) dozens of<br>
categories that exceed this limit e.g. "marine biology", "yacht cruising", etc.<br>
<br>
Does anyone know of a quick way to modify the field length in SQL "on the fly"?<br>
<br>
Many thanks - the alternative is to manually correct tens of thousands of<br>
entries spread across hundreds of spreadsheets.<br>
<br>
Paul<br>
<br>
_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</blockquote></div><br>