Hey, Yes, body and header values are getting stored in BLOB. When you retrive them you get actual values (readable content).
Thanks, Sai On Sat, Feb 23, 2013 at 1:30 AM, seyoum tesfay <syumtes...@gmail.com> wrote: > Hi Saibabu, > > I understand now. I can see the columns James_Mail.Mail_Bytes and > James_Mail.Header_Bytes. The value in these columns is given in something > like [BLOB - 76B] > But I was expecting the value to such columns to be exact textual value > (like header value or body of email message). So, is the body and header > values getting stored in just [BLOB-...] values? > > regards, > > > > *Seyoum T*. > > > > On Fri, Feb 22, 2013 at 1:37 PM, Saibabu Vallurupalli < > saibabu.vallurupa...@gmail.com> wrote: > > > Hi Seyoum, > > > > What Eric means is Message is of type Blob and you can find this in table > > JAMES_MAIL column MAIL_BYTES and MAIL_HEADER will have all email header > > content. > > > > Hope this helps. > > > > Thanks, > > Sai > > > > > > On Fri, Feb 22, 2013 at 3:32 AM, seyoum tesfay <syumtes...@gmail.com> > > wrote: > > > > > Hi Eric, > > > > > > Thank you for your reply but there is no MESSAGE.BLOB column in the > > tables > > > created by James server 3.0-beta4. There is no table called Message in > > the > > > tables. > > > > > > regards, > > > > > > > > > *Seyoum T*. > > > > > > > > > > > > On Thu, Feb 21, 2013 at 3:26 PM, Eric Charles <e...@apache.org> wrote: > > > > > > > Hi, > > > > Look at MESSAGE.BLOB for the body of the mail. > > > > Thx, Eric > > > > > > > > > > > > On 21/02/2013 05:53, seyoum tesfay wrote: > > > > > > > >> Hello, > > > >> > > > >> I am using James server 3.0-beta4 with MySql database as the mail > and > > > user > > > >> repository. James users different table to store the mail and user > > > >> information in the database such as james_user, james_domain, > > > james_mail, > > > >> james_mailbox, james_mail_property, etc. > > > >> > > > >> So, my question is where exactly is the actual mail message getting > > > >> stored? > > > >> the james_mail table stores metadata about the mail. But I couldn't > > find > > > >> where and how the user mails are getting stored. > > > >> > > > >> regards, > > > >> > > > >> *Seyoum T*. > > > >> > > > >> > > > > > > ------------------------------**------------------------------**--------- > > > > To unsubscribe, e-mail: server-user-unsubscribe@james.**apache.org< > > > server-user-unsubscr...@james.apache.org> > > > > For additional commands, e-mail: server-user-help@james.apache. > **org< > > > server-user-h...@james.apache.org> > > > > > > > > > > > > > >
