Well, before we get too carried away with trying to make the Dewey number a number, let's ask ourselves if there is really any good reason to keep it a number! It's not used in any sort of calculation, for example. Stephen MJ Ray said:
On 2004-08-12 20:25:11 +0100 Chris Cormack <chris@katipo.co.nz> wrote:
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.
Stupid mysql. Is sprintf("%06.2f\n",$dewey) simple enough, or is it a problem with how many places Dewey is displayed? (Inspired by man perlfaq4)
Maybe making it character would help LC support, though. Maybe even the same search range theory could work with both, but I forget the specifics of SQL character fields and range operators.
-- MJR/slef My Opinion Only and not of any group I know http://www.ttllp.co.uk/ for creative copyleft computing Please email about: BT alternative for line rental+DSL; Education on SMEs+EU FP6; office filing that works fast
------------------------------------------------------- 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