On Sun, 2004-08-22 at 22:49, MJ Ray wrote:
On 2004-08-22 12:06:33 +0100 Indranil Das Gupta <indradg@icbic.com> wrote:
Why is the biblioitems.dewey field set to double(8,6) and not to, say varchar(15) or something like that?
I think quite a few developers have been wondering that recently, too. Unless there's a killer reason to keep it numeric, I expect it to change in 2.1.* before much longer.
Thanks for the info. At my deployment site, use of double precision datatype was leading to the decimal part of the stored dewey number being padded with extra zeros. And this was reflecting a wrong value in the OPAC interface. So, I simply changed the fieldtype to varchar(15) and rerun misc/rebuildnonmarc.pl. Now, the dewey value is being correctly stored in biblioitems.dewey and properly displayed in the OPAC. So far, I haven't noticed any inconsistency due to the change. cheers, -indra. -- ------------------------------------------------------------- Indranil Das Gupta, Project Lead, CASTLE Project [Computer Aided Studies, Teaching and Learning Environment] In collaboration with: West Bengal University of Technology Calcutta, INDIA www.wbut.net ------------------------------------------------------------- L2C2.ORG - Bringing Localized Low-Cost Computing to People -------------------------------------------------------------