[Koha-devel] Length of email columns

[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) 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 at biblibre.com>
BibLibre