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.maur...@biblibre.com>
BibLibre
_______________________________________________
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/

Reply via email to