[Koha-devel] Dewey character

[Chris Cormack]

On Thu, Aug 12, 2004 at 12:49:20PM +0100, MJ Ray said:
> On 2004-08-12 11:06:11 +0100 Stephen Hedges <shedges at 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 at katipo.co.nz                                          www.katipo.co.nz