On Wed, 21 Dec 2005, Thomas Bruederli wrote:
The from and to fields in the message table are primarily used for sorting when taking all message headers from the cache. The "real" content is delivered by the serialized content. Therefore I decided to not use more than 128 chars for these headers because just for sorting it should be enough. In MySQL, the content is automatically chopped if it's longer than the specified field length and I assumes that every database acts this way. If it's causing errors, the PHP script should chop those strings before inserting.
Normaly a database engine shouldn't change the data that is been inserted, but it's well known that MySQL does that.
Other thoughts?
substr($string,0,128) in all the fields would be OK.
-- 07:10:01 up 15:52, 0 users, load average: 0.00, 0.01, 0.06
Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador