Re: How to store emails with fulltext index

Hello,

> And no - Oracle is an RDBMS, not an email server, and does not
> know email record types.

well, I just thought that some databases have special record types for objects, 3d coordinates, barcodes etc.; so maybe some database has RFC822 as well.

> I would think oracle stores the email in CLOBs (Character Large
> OBjects), attachments in BLOBs (Binary Large Objs). Both
> can be indexed, using OracleText.

There is another point: MOst emails are indeed pure text, so there the size could be reduced very much using compression. But I don't know if it is possible to compress the mail on the one hand and have a fulltext index on the other.

> Of course, you could buy an Oracle Collaboration Suite licence,
> which includes Oracle's email implementation - better than Exchange,
> so they say.

Well, we don't need Exchange or a Collaboration Suite as we are developing an own special collab/ticket software customized to our needs which integrates perfectly into our own CRM software.

> Oh - and varchar2 objects can be text indexed as well; guess
> the majority of mails fits in 4000 characters (using a decent
> mail program, that produces plain text), like TBird

I wouldn't swear that all messages have a size of less than 4000 characters. Surely, most messages are smaller, but what shall I do with messages greater than that? Is the maximum limit of varchar2 really 4k? I cannot imagine that. I've seen much greater values at MySQL, Postgresql or Sybase.

Regards
Marten Received on Tue Nov 27 2007 - 16:38:30 CST