> 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]