16 Feb
2018
16 Feb
'18
10:54 a.m.
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