Hi folks,

I'm about to create a table that will store event notifications the will be emailed later.

I'm second guessing what would be the best datatype for the column that will contain the email "body". The format would mostly be plain text but should also support HTML in the future. What would be best datatype for the application. CLOB or BLOB?

Thanks for your advice.

Regards,
Mario

Mario


CLOB

This means that its human readable, will support plain text, html  (html is just plain text with formatting instructions) and mime or uu encoded text. If desired at a future point you can add a full text index. Its usable via .AsString

Definitely CLOB

Roy Lambert

Thank you Roy