james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danny Angus <Danny_An...@slc.co.uk>
Subject RE: Status, Release Candidates and Derby
Date Mon, 19 Dec 2005 09:04:32 GMT

> A better datatype would be CLOB, then you could have up to 2Gb character
limit.
> I don't believe this would require any application changes (moving to a
CLOB).

> We've seen some odd behavior dealing with CLOBs with some drivers, hence
the
> useBlob vs useBytes attibute in sqlResources.  Would that apply here?

IIRC there could be issues relating to the character encoding used in the
CLOB or the stream it is exposed as, mail is notorious in its ability to
mix encodings within a single message, a BLOB is more "raw" than a CLOB
which presupposes that it contains characters. This may explain our
historic choice of BLOB vs CLOB, or it may be wrong.

Field size for this is worth knowing about though, James would need to have
db field size >= max allowed message size.

d.


***************************************************************************
The information in this e-mail is confidential and for use by the addressee(s) only. If you
are not the intended recipient (or responsible for delivery of the message to the intended
recipient) please notify us immediately on 0141 306 2050 and delete the message from your
computer. You may not copy or forward it or use or disclose its contents to any other person.
As Internet communications are capable of data corruption Student Loans Company Limited does
not accept any  responsibility for changes made to this message after it was sent. For this
reason it may be inappropriate to rely on advice or opinions contained in an e-mail without
obtaining written confirmation of it. Neither Student Loans Company Limited or the sender
accepts any liability or responsibility for viruses as it is your responsibility to scan attachments
(if any). Opinions and views expressed in this e-mail are those of the sender and may not
reflect the opinions and views of The Student Loans Company Limit
 ed.

This footnote also confirms that this email message has been swept for the presence of computer
viruses.

**************************************************************************

---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org


Mime
View raw message