I have seen databases (not MySQL) getting corrupted because the file inserted was to big.
For the visitor it doesn't really matter whether you put it into the database or not. A link is less difficult and you don't have to retrieve pictures from the database so it might be quicker..
B.
At 18:34 20-03-2003 +0000, Lai Liu-yuan wrote:
I am now having a database storing images of chinese characters for research purpose. I wrote a program to store and retrieve them. My images are of type ppm. This is how I designed my table:
mysql> describe poor; +--------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+----------------+------+-----+---------+-------+ | cc | char(2) binary | | | | | | width | int(1) | YES | | NULL | | | height | int(1) | YES | | NULL | | | data | blob | YES | | NULL | | +--------+----------------+------+-----+---------+-------+
Just have to be really careful in storing binary data. Hope this help.
On Thu, 20 Mar 2003 10:34:19 +0100 [EMAIL PROTECTED] wrote:
> Hi! > > I have a problem with my MySQL > > I need to have some a images related with an item > > for example > > ------------------------------------------ > ! author ! date of birth an death ! image! > ------------------------------------------ > > How can I define the field for the images? I have read that LONGBLOB > could be useful for large objct like images, but I can't understand how > to set it in my database... > > Thank you in advance > > stefano > -- > S t e f a n o C a r d o > Debian GNU-Linux user >
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
