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