Re: store JPG in MySQL DB

2002-05-20 Thread Cecil Brand
quot;Andrei Cojocaru" <[EMAIL PROTECTED]> Cc: "Sameer Maggon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 9:37 AM Subject: Re: store JPG in MySQL DB > > Hi Andrei > > > If I were you I would not store a binary file into the databa

Re: store JPG in MySQL DB

2002-05-20 Thread Andrei Cojocaru
Cc: "Sameer Maggon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 9:54 AM Subject: Re: store JPG in MySQL DB > > Hi Andrei > > > well, let's just say if it crashes it will mean longer recovery time, you > > are adding extra process

RE: store JPG in MySQL DB

2002-05-20 Thread Soheil Shaghaghi
) to their profile. Thanks so much, Soheil -Original Message- From: Sherzod B. Ruzmetov [mailto:[EMAIL PROTECTED]] Sent: Mon, May 20, 2002 8:37 AM To: Andrei Cojocaru Cc: Sameer Maggon; [EMAIL PROTECTED] Subject: Re: store JPG in MySQL DB Hi Andrei > If I were you I would not stor

Re: store JPG in MySQL DB

2002-05-20 Thread Sherzod B. Ruzmetov
l Message - > From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]> > To: "Andrei Cojocaru" <[EMAIL PROTECTED]> > Cc: "Sameer Maggon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, May 20, 2002 9:37 AM > Subject: Re: store

Re: store JPG in MySQL DB

2002-05-20 Thread Andrei Cojocaru
t; > > > > > Andrei Cojocaru > > [EMAIL PROTECTED] > > - Original Message - > > From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]> > > To: "Sameer Maggon" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> >

Re: store JPG in MySQL DB

2002-05-20 Thread Andrei Cojocaru
t; To: "Sameer Maggon" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 12:26 AM Subject: Re: store JPG in MySQL DB > > For real-life example, check out http://cdbaza.ultracgis.com, and check > out the filename > of the thumbnails image

Re: Re: store JPG in MySQL DB

2002-05-20 Thread Sameer Maggon
Hi, That explains me a problem but i could not see strmov() function any where, while linking with -lmysqlclient also it gives unreferenced function.. I am using Mysql 3.23 Please help Sameer -- you wrote: Sameer, Monday, May 20, 2002, 11:17:48 AM, you wrote: SM> Can you please

Re: Re: store JPG in MySQL DB

2002-05-20 Thread Victoria Reznichenko
Sameer, Monday, May 20, 2002, 11:17:48 AM, you wrote: SM> Can you please put some light on it.. How i can do it, or is SM> it described in manual You can insert file into BLOB field using INSERT statement and retrieve file using SELECT. To insert file you can use LOAD_FILE() function:

Re: store JPG in MySQL DB

2002-05-19 Thread Sherzod B. Ruzmetov
For real-life example, check out http://cdbaza.ultracgis.com, and check out the filename of the thumbnails images. I'm SELECTing those images from the MySQL database. That's how it's done: 1_ Create a table to store your JPGs, and the column that holds JPG data should be declared as BLOB

Re: store JPG in MySQL DB

2002-05-19 Thread Sameer Maggon
Hi, Can you please put some light on it.. How i can do it, or is it described in manual Sameer -- you wrote: Hi > Hi, > Can i have a table in which i can store my JPG file somehow in > MYSQL database. Absolutely. just declare a BLOB column, and load your images rightinto the col

Re: store JPG in MySQL DB

2002-05-19 Thread Sherzod B. Ruzmetov
Hi > Hi, > Can i have a table in which i can store my JPG file somehow in > MYSQL database. Absolutely. just declare a BLOB column, and load your images rightinto the columsn > Sameer > > > > > > > > -- > http://www.dypatil.edu For Better tomorrow > > -