[Koha-devel] Field width for currency.currency is inadequate

[Indranil Das Gupta]

Hi all,

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)


The bug and the patches are here
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14179

cheers
-idg
-- 
Indranil Das Gupta

Phone : +91-98300-20971
Blog    : http://indradg.randomink.org/blog
IRC      : indradg on irc://irc.freenode.net
Twitter : indradg

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
Please exchange editable Office documents only in ODF Format. No other
format is acceptable. Support Open Standards.

For a free editor supporting ODF, please visit LibreOffice -
http://www.documentfoundation.org