On Thu, 2009-06-11 at 05:53 -0700, Brian Neu wrote: > The database is a Postgres UTF8, and forgive my ignorance here, but > will that cover any kind of email address with a VarChar column type, > or is there still a need for VarBinary?
With text-columns in a UTF-8 database you can get errors concerning "invalid UTF-8 byte sequence", if an "email address" contains a byte sequence which does not form a valid utf-8 char (with LATIN-1 you would not have this problem, because every single byte is a valid one in LATIN-1). > I'm assuming that by using VarBinary I'll be losing the capability to > do string-based queries with wildcards such as "LIKE '%domain.com'. > Is that correct also? I am using "bytea" columns in postgres (don't know if this is the same as VarBinary). And with bytea I can successfully execute statements like SELECT * FROM maddr WHERE email LIKE '%business%'. This is possible due some internal "decoders" (i.e. bytea->utf-8) which are implicitly used in such cases (they can also be used explicitly by using some syntax like with "USING ...", but I can't remember the exact way how to do this). (I did not follow the whole thread, my response only got triggered by the Postgres-question - so sorry if I am off-topic) Regards -stefan- > --- On Thu, 6/11/09, Mark Martinec <mark.martinec+ama...@ijs.si> wrote: > > > From: Mark Martinec <mark.martinec+ama...@ijs.si> > > Subject: Re: [AMaViS-user] 2.6.3 with Postgres causing "ERROR: operator > > does not exist: bytea = character varying" > > To: amavis-user@lists.sourceforge.net > > Date: Thursday, June 11, 2009, 5:23 AM > > 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/ > > > > ------------------------------------------------------------------------------ > 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/ ------------------------------------------------------------------------------ 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/
