<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812"></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Greetings,</DIV>
<DIV> </DIV>
<DIV>I'm trying to determine what the maximum size of attachments that I can use through RT. We have some users that want to put larger attachments in there.</DIV>
<DIV> </DIV>
<DIV>Can anyone tell me where the attachments are stored in the database, and if you know, what data type it's been defined as?</DIV>
<DIV> </DIV>
<DIV>I understand that when you are storing files in a database, you need to choose a type, and that dictates the max file size.</DIV>
<DIV> </DIV>
<DIV>I want to go over the "recommended" size that's in the Site Config file(10mb) but I need to know how the DB is storing the files so I know what my limits are to test.</DIV>
<DIV> </DIV>
<DIV>RT - 3.2.1 (I know I know... upgrade... I just don't have the time right now) </DIV>
<DIV>MySQL 4</DIV>
<DIV> </DIV>
<DIV>Thanks!</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Mike Johnson<BR>Datatel Programmer/Analyst<BR>Northern Ontario School of Medicine<BR>955 Oliver Road<BR>Thunder Bay, ON P7B 5E1<BR>Phone: 807.766.7331<BR>Email: <A href="mailto:mike.johnson@normed.ca">mike.johnson@normed.ca</A></DIV>
<DIV>Technology assistance: email <A href="mailto:nosmhelpdesk@normed.ca">nosmhelpdesk@normed.ca</A> <BR>Technology Emergency Contact (TEC) Mon-Fri, 8am to 5pm excluding stat holidays: <BR>Off campus toll free 1-800-461-8777, option 8, or locally either <BR>(705)-662-7120 or (807)-766-7500<BR></DIV></BODY></HTML>