Jorge Bastos wrote: > Paul/Aaron, > The field here on headername with a varchar(100) should be text to > prevent something bigger? > Like the dbmail_headervalue that has a text type > > CREATE TABLE dbmail_headername ( > id BIGINT NOT NULL AUTO_INCREMENT, > headername VARCHAR(100) NOT NULL DEFAULT '', > PRIMARY KEY (id), > UNIQUE (headername) > ) ENGINE=InnoDB ;
Imo, headernames longer than 100 chars are *not* sane, if at all valid. If you encounter headernames that dont fit on a regular basis, let me know. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl