Re: store JPG in MySQL DB

2002-05-20 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: 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: 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: store JPG in MySQL DB

2002-05-20 Thread Andrei Cojocaru
[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 images. I'm SELECTing those images from the MySQL database. That's how it's

Re: store JPG in MySQL DB

2002-05-20 Thread Andrei Cojocaru
wouldn't use it. Andrei Cojocaru [EMAIL PROTECTED] - Original 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 JPG in MySQL DB Hi

Re: store JPG in MySQL DB

2002-05-20 Thread Sherzod B. Ruzmetov
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 database, I'd store the information required to fetch it from somewhere else like

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 store

Re: store JPG in MySQL DB

2002-05-20 Thread Andrei Cojocaru
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 processing to the SQL server to handle data it wasn't meant to handle, storing it in the file system has the main

Re: store JPG in MySQL DB

2002-05-20 Thread Cecil Brand
, 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 database, I'd store the information required to fetch it from somewhere else like the mySQL manual suggests But what difference does it make? Besides, I found storing

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

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