Another option is to create a field where you store the url of the picture, and store the pictures in a especific folder. You can do this very easy with phpMyAdmin. If this solution do not helps you, use the BLOB type as Dan Nelson said. Both options are OK, I think.
Hope this can help you. Alvaro. > ----- Original Message ----- > From: "Dana Terrell" <[EMAIL PROTECTED]> > To: <mysql@lists.mysql.com> > Sent: Friday, April 15, 2005 6:52 PM > Subject: A picture perfect problem > > > > I thank one and all for your help with my last problem and now I come to > you > > with another that has crept up. My superiors have decided that they also > > want to store photographs in the database as well. I know that in > > MSSqlServer I can set a field to ole datatypes and it will store photos, > but > > I don't see that in the datatypes list for MySql, nor do I see anything in > > the list that looks like it would work. Can photos be stored in MySql and > > if so, what is the datatype to use to accomplish this task? Again, Thank > > you for your help in the past and I hope someone can help me now. > > > > > > > > Dana Terrell > > > > > > -- > > No virus found in this outgoing message. > > Checked by AVG Anti-Virus. > > Version: 7.0.308 / Virus Database: 266.9.11 - Release Date: 4/14/2005 > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]