[daisy] [JIRA] Resolved: (DSY-653) Decimal fields don't store numbers greater than 99'999

[Karel Vervaeke (JIRA)]

     [ http://issues.cocoondev.org//browse/DSY-653?page=all ]
     
Karel Vervaeke resolved DSY-653:
--------------------------------

    Resolution: Duplicate

Duplicate of DSY-652.  Jira gave an error message the first time so I assumed no issue was created.

> Decimal fields don't store numbers greater than 99'999
> ------------------------------------------------------
>
>          Key: DSY-653
>          URL: http://issues.cocoondev.org//browse/DSY-653
>      Project: Daisy
>         Type: Improvement
>   Components: Repository - database support
>     Versions: 2.2
>     Reporter: Karel Vervaeke
>     Assignee: Karel Vervaeke
>     Priority: Minor
>      Fix For: 2.3

>
> Originally reported by Olivier Lange, confirmed by Andreas Deininger.
> Suggested solution: change database field type to DECIMAL(24,9)
> This would allow  values between
> - 999 999 999 999 999 . 999 999 999
> and
> + 999 999 999 999 999 . 999 999 999
> (storing 5x3 = 15 digits before the decimal point and 3x3 = 9 after the decimal point)
> Will implement this shortly, if anyone disagrees with the suggested solution, react as soon as possible.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira