Steve Grosz <[EMAIL PROTECTED]> wrote:
> I'm just getting into the whole MySql (was using access). Is it better
> to create a Blob type and insert a image into it, or to create a char
> file type and have a directory structure to the specific file?
It's FAQ. One of the most FA Q.
Store image
I'm just getting into the whole MySql (was using access). Is it better
to create a Blob type and insert a image into it, or to create a char
file type and have a directory structure to the specific file?
How big of files to the different Blob's hold? And if I'm using
Coldfusion, will that sup
> What I need to know is:
> 1. what would the create table statment look like in Mysql.
DROP TABLE IF EXISTS pictures;
CREATE TABLE pictures (
id mediumint(4) NOT NULL auto_increment,
comment text NOT NULL,
width smallint(6) DEFAULT '0' NOT NULL,
height smallint(6) DEFAULT '0' NOT NUL
Thanks, regarding the PHP info.
What I need to know is:
1. what would the create table statment look like in Mysql.
2. Should I use a longblob based on my 100k .gif size?
3. Is one column with the gifs enough. Or should I add a autoincremented
primary key?
4. Is it better to have a seperat
Generally, it is not advised to add pictures to tables. See
http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images
We had this question here some days ago, so it may ge a good idea
to discuss at length possible problems why people won't like this
approach of storing pics as files.
WARNING: thi
Hi, I'm new to blobs.
I want to create a seperate table that will hold blob's or pictures.
Each picture will be a .gif and will not exceed 100k in size.
each image will be called, ord.gif, bar.gif, cmi,gif, lax.gif, jfk.gif,
ord.gif, etc.
The questions I had were
1. what would the create table
Hello avegaaraya,
Thursday, May 31, 2001, 6:12:09 PM, you wrote:
ann> I'm using mysql in win9x, and I want to know how to load a JPG image into a table
ann> __
ann> Get your own FREE, personal Netscape Webmail account today at
http
I'm using mysql in win9x, and I want to know how to load a JPG image into a table
__
Get your own FREE, personal Netscape Webmail account today at
http://webmail.netscape.com/