<div dir="ltr">Hello Michael,<div><br></div><div>Thank you for sharing your experience. It is new learning that multiple email addresses can be used in one field.</div><div><br></div><div>All the best.</div><div>Kamal</div><div><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Michael Hafen</b> <span dir="ltr"><<a href="mailto:michael.hafen@washk12.org">michael.hafen@washk12.org</a>></span><br>Date: Sat, Feb 17, 2018 at 12:02 AM<br>Subject: Re: [Koha-devel] Length of email columns<br>To: Owen Leonard <<a href="mailto:oleonard@myacpl.org">oleonard@myacpl.org</a>><br>Cc: "<a href="mailto:koha-devel@lists.koha-community.org">koha-devel@lists.koha-community.org</a>" <<a href="mailto:koha-devel@lists.koha-community.org">koha-devel@lists.koha-community.org</a>><br><br><br><div dir="ltr">In my case I import information on students for school libraries into Koha, and there are often multiple email addresses in one field.</div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">On Fri, Feb 16, 2018 at 6:36 AM, Owen Leonard <span dir="ltr"><<a href="mailto:oleonard@myacpl.org" target="_blank">oleonard@myacpl.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span>> According to <a href="https://stackoverflow.com/a/574698" rel="noreferrer" target="_blank">https://stackoverflow.com/a/57<wbr>4698</a> the maximum length of an<br>
> email address is 254 characters, so VARCHAR(255) should be enough.<br>
> Do you know if there is any reason why we use mostly TEXT and MEDIUMTEXT<br>
> for these columns ?<br>
<br>
</span>Is there ever a situation where we want to allow multiple email<br>
addresses in one field? I don't know if that's even possible in Koha,<br>
but I seem to recall discussion of it in the past.<br>
<span class="m_-7748815226044814185HOEnZb"><font color="#888888"><br>
 -- Owen<br>
</font></span><div class="m_-7748815226044814185HOEnZb"><div class="m_-7748815226044814185h5">______________________________<wbr>_________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-communit<wbr>y.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.or<wbr>g/cgi-bin/mailman/listinfo/koh<wbr>a-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org<wbr>/</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br><div class="m_-7748815226044814185gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div>Michael Hafen<br></div>Washington County School District Technology Department<br></div>Systems Analyst<br><br></div></div></div></div>
</font></span></div>
<br>______________________________<wbr>_________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-<wbr>community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.<wbr>org/cgi-bin/mailman/listinfo/<wbr>koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.<wbr>org/</a><br></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="font-size:12.8px">Kamal Hossain</div></div><div dir="ltr"><div>Sr. Assistant Librarian</div><div>University of Liberal Arts Bangladesh (ULAB)</div><div>House 56, Road 4/A, Dhaka 1209</div><div>Bangladesh</div><div>Tel: 9661255, 9661301 (Ext. 203)<br>Cell : 01817042481<br></div><div>Fax: 9660610</div><div><a href="mailto:Email%3Akamal.hossain@ulab.edu.bd" target="_blank">Email:kamal.hossain@ulab.edu.bd</a></div><div>Website:<a href="http://www.ulab.edu.bd" target="_blank">www.ulab.edu.bd</a></div><div><br></div><div><br></div></div></div></div></div></div></div></div></div></div></div>
</div></div>