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