I'd be wary of this approach. I don't remember well what happens, but the dewey number is decimal for sorting, and the J will be in a separate field (but I can't remember where precisely. If you are using the Dewey system don't tamper with the datatype. On the other hand if you are using another system feel free to modify the type to suit, but there may be some other validation and formatting that has to change, for example formatting that puts leading zeroes on dewey numbers less than 100. -----Original Message----- From: Roger Buck [mailto:rog@saas.nsw.edu.au] Sent: Tuesday, 30 April 2002 11:07 To: rachel@katipo.co.nz Cc: Yaogeng Cheng; koha@lists.katipo.co.nz Subject: Re: [Koha] A simple question about Class # From the example koha db tables for <biblioitems.dewey>: dewey double (8,6) default NULL I think this means that the dewey entry is restricted to being a numeric data type (double precision - up to 8 digits displayed, with up to 6 digits following the decimal point)? As far as I know, the Dewey numbers are "labels" - their value is not used for computation - so the dewey number could be entered as a "text" data type? I'd guess that simply changing the db entry to something like: dewey varchar (16) default NULL might cover most of your needs? I am just a newbie at this stuff and the above is all just guess-work - so make modifications at your own risk ;^) R. _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha