In my case I import information on students for school libraries into Koha, and there are often multiple email addresses in one field. On Fri, Feb 16, 2018 at 6:36 AM, Owen Leonard <oleonard@myacpl.org> wrote:
According to https://stackoverflow.com/a/574698 the maximum length of an email address is 254 characters, so VARCHAR(255) should be enough. Do you know if there is any reason why we use mostly TEXT and MEDIUMTEXT for these columns ?
Is there ever a situation where we want to allow multiple email addresses in one field? I don't know if that's even possible in Koha, but I seem to recall discussion of it in the past.
-- Owen _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Michael Hafen Washington County School District Technology Department Systems Analyst