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