[Koha-devel] Dewey character

[MJ Ray]

On 2004-08-12 20:25:11 +0100 Chris Cormack <chris at 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