Re: [Koha-devel] Dewey character

[Stephen Hedges]

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 <address@hidden>
>> 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
> address@hidden
> 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
> address@hidden
> https://lists.sourceforge.net/lists/listinfo/koha-devel
>


-- 
Stephen Hedges
Skemotah Solutions, USA
www.skemotah.com  --  address@hidden