[Koha-devel] Length of email columns

2018-02-16 Thread Julian Maurice
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) sho

Re: [Koha-devel] Length of email columns

2018-02-16 Thread Owen Leonard
> 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

Re: [Koha-devel] Length of email columns

2018-02-16 Thread Michael Hafen
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 wrote: > > According to https://stackoverflow.com/a/574698 the maximum length of an > > email address is 254 charac