[Koha] SQL field lengths

[Susan Bennett]

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 at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20101129/2d3c279a/attachment.htm