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@gmail.com Reporter: indradg@gmail.com QA Contact: testopia@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.