Re: How to store images in MySql table

At 15:54 +0530 6/15/02, Saju wrote: >Hi, >I want to store images in MySQL table. > >Is it by creating a table with one of its fields a BLOB type. >Then how will i insert the image into the table. It's no different than any other kind of data: - Use a placeholder and bind th

RE: How to store images in MySql table

Have you thought of just storing the path to each image instead of using BLOBs? - Michael -Original Message- From: Saju [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 15, 2002 3:25 AM To: [EMAIL PROTECTED] Subject: How to store images in MySql table Hi, I want to store images in

How to store images in MySql table

Hi, I want to store images in MySQL table. Is it by creating a table with one of its fields a BLOB type. Then how will i insert the image into the table. Thanks Saju

RE: Images in MySQL

From: Paul DuBois To: Jeff Thies Cc: [EMAIL PROTECTED] Sent: 9/7/01 10:54 AM Subject: Re: Images in MySQL > > This is sort of OT and not. >> >> BLOB is binary, don't think you need to specify twice:-) Take off the >> binary part. >> >> It doesn't

Re: Images in MySQL

fficient long term >> solution for you. >> >> Don't forget to set LongReadLen and LongTruncOk when retrieving images, and >> you must use placeholders when inserting them. >> >> Ilya >> >> -Original Message- >> From: Todd M

Re: Images in MySQL

ficient long term > > solution for you. > > > > Don't forget to set LongReadLen and LongTruncOk when retrieving images, and > > you must use placeholders when inserting them. > > > > Ilya > > > > -Original Message- > > From: Todd Mo

RE: Images in MySQL

You are not wrong and not right. Since this is now off topic, this discussion should not continue, though you should look into html tag. Ilya -Original Message- From: Jeff Thies Cc: 'dbi-users ' Sent: 9/7/01 10:05 AM Subject: Re: Images in MySQL > This is sort

Re: Images in MySQL

ongTruncOk when retrieving images, and > you must use placeholders when inserting them. > > Ilya > > -Original Message- > From: Todd Moy > To: dbi-users > Sent: 9/7/01 10:32 AM > Subject: Images in MySQL > > Hello all: > Just a quick question concerni

RE: Images in MySQL

ngs and see what's a more efficient long term solution for you. Don't forget to set LongReadLen and LongTruncOk when retrieving images, and you must use placeholders when inserting them. Ilya -Original Message- From: Todd Moy To: dbi-users Sent: 9/7/01 10:32 AM Subject: Imag

Images in MySQL

Hello all: Just a quick question concerning putting images in a database- I want to add a field for images within my mysql database: how should I go about doing this? I have tried -- ALTER TABLE project ADD(proj_img blob binary); -- ...to no avail. What is the correct syntax? Also, is this even a