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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
