Binary Attachments in the database

Hi All,

We are moving through a conversion of RT to Oracle. One issue that we are
running accross is the storage of attachments in the database. Looking
back on our test install on MySQL, it looks like only the text type
attachments were making it to the DB. How does RT go about storing the
binary attachments (images and such). Can these go into mysql when the
content column type is ‘memo’?

We are thinking we will have to use something like BLOBs for the Oracle
conversion, but need to get a better handle on how it works on mysql first.
Any insights would be appreciated.

Thanks and cheers,

Brian

This email and any files transmitted with it, are confidential and is intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please notify the system manager.

This footnote also confirms that this email message has been scanned by AUSTAR Communications content and virus scanning applications
for the presence of computer viruses.

Brian Houston/NCO/CEtv wrote:

We are moving through a conversion of RT to Oracle. One issue that we are
running accross is the storage of attachments in the database. Looking
back on our test install on MySQL, it looks like only the text type
attachments were making it to the DB.

Um. RT 2.x has, as far as I know, always stored all attachments
in the DB, regardless of type (but with regard to the maximum
allowed attachment size in the RT config and in the database
config.)
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances