[Koha] A simple question about Class

[Williams, Olwen - SAL]

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 at saas.nsw.edu.au]
Sent: Tuesday, 30 April 2002 11:07
To: rachel at katipo.co.nz
Cc: Yaogeng Cheng; koha at 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 at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha