Brian, > HEY, it's the email column
Ah, ok, that makes more sense. > which is bytea --- on my other amavis server > it's character varying 255 . . . . why the change? Because in principle an envelope e-mail address can happen to contain any junk, an if there are any 8-bit characters there, there is no guarantee it will be valid string according to a character set chosen for an SQL field. So it's prudent not to require an e-mail address to be in any particular character set, but declare it as a string of octets. See release notes (2.6.0), search for: - when SQL logging (pen pals) or SQL lookups are used, one can choose a binary or a character data type for fields users.email, mailaddr.email, and maddr.email; now may be a good opportunity to change a data type to binary (string of arbitrary bytes, no character set associated). Background: ... Mark ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
