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 > > --------------------------------------------------------------------- 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
