EPrints Technical Mailing List Archive

Message: #05613

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Longtext field: maxlength

Hi,
Just discovered something that might be useful for others to know:
An EPrints longtext field has a default max character length of 65535 (quite a bit shorter than a database longtext field).
https://github.com/eprints/eprints/blob/3.3/perl_lib/EPrints/MetaField/Longtext.pm#L115

The wiki documentation for a longtext field doesn't mention this default limit.

As this is a default, it can be overridden in the repository config for a field:
{
        name => 'referencetext',
        type => 'longtext',
        input_rows => 15,
        maxlength => 120000, #MySQL longtext can theoretically handle 4G?
},

Hope that helps someone in the future - someone just uploaded a thesis with 90,000 bytes of reference text - which is how I discovered this!
Cheers,
John