Hello Michael,

Thank you for sharing your experience. It is new learning that multiple email addresses can be used in one field.

All the best.
Kamal

---------- Forwarded message ----------
From: Michael Hafen <michael.hafen@washk12.org>
Date: Sat, Feb 17, 2018 at 12:02 AM
Subject: Re: [Koha-devel] Length of email columns
To: Owen Leonard <oleonard@myacpl.org>
Cc: "koha-devel@lists.koha-community.org" <koha-devel@lists.koha-community.org>


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


_______________________________________________
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/



--
Kamal Hossain
Sr. Assistant Librarian
University of Liberal Arts Bangladesh (ULAB)
House 56, Road 4/A, Dhaka 1209
Bangladesh
Tel: 9661255, 9661301 (Ext. 203)
Cell : 01817042481
Fax: 9660610