Well the back end is a problem, too. There's no standard number of digits after the decimal, it can vary from book to book. Seems like character is the only logical choice. Stephen Chris Cormack said:
On Thu, Aug 12, 2004 at 12:49:20PM +0100, MJ Ray said:
On 2004-08-12 11:06:11 +0100 Stephen Hedges <shedges@skemotah.com> wrote:
I think we really should change the dewey column to character data instead of number data.
Can we set it to a fixed x.y number and trim trailing 0s, or have I misunderstood Dewey Decimal again? I have my financial database set to a *.2 number, to avoid floating point errors entering my accounting systems.
The problem is that mysql helpfully trims leading 0's. Which are perfectly valid in Dewey. So we would have to write code to add 0's to the front if we did that.
CHris
-- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com