[Koha-bugs] [Bug 14179] New: Field width for currency.currency is inadequate

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14179

            Bug ID: 14179
           Summary: Field width for currency.currency is inadequate
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: P4
         Component: Database
          Assignee: gmcharlt at gmail.com
          Reporter: indradg at gmail.com
        QA Contact: testopia at bugs.koha-community.org

The database field currency.currency is defined as VARCHAR(10) NOT NULL. This
needs to be increased e.g. set as VARCHAR(255) NOT NULL.

The rationale:

a) While it is possible to accomodate 'US Dollar' in that width, for many
currencies this space is inadequate e.g. 'East Caribbean Dollar', 'Indian
Rupee' or 'Tanzanian Shilling'. 

b) Further, in the 'New currency' addition form, the maxlength and size
attributes are set as 50, and allows user to enter long names as examples
above. While saving the record, it is truncated to VARCHAR(10).

I propose the following:

1/ Alter the currency.currency field to VARCHAR(255) NOT NULL from VARCHAR(10)
NOT NULL.

2/ Change the 'maxlength' attribute in the template to 255 (to match column
property)

-- 
You are receiving this mail because:
You are watching all bug changes.