Length of email columns
Hi, In the database schema, we use different data types to store email adresses. Some are TEXT, some are MEDIUMTEXT, and there is aqcontacts.email which is a VARCHAR(100). 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 ? -- Julian Maurice <julian.maurice@biblibre.com> BibLibre
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
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
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 Email:kamal.hossain@ulab.edu.bd Website:www.ulab.edu.bd
participants (4)
-
Julian Maurice -
Kamal Hossain -
Michael Hafen -
Owen Leonard