Hi,

I am a totally newbie to MySQL. Have read the book front-to-back with great pleasure. One of the best and most instructive books for me so far - being a newbie. Excellent step by step examples and very easy to follow.

Got a definitions question from Chap 5, p159, Table with 'table types'.

My problem is:
Would like to make a table with one of the columns being a BLOB type.
(For pictures, icons, PDF's, Photos, etc.) - Best suited for this purpose is the MyISAM as far as I can figure?? (p160)

Additionally to the table, I would like to have a column - 'Type', indicating what the BLOB object is. I would prefer 'Type' to be a foreign key, but does MyISAM support the foreign key functionality I need satisfactorily?

Based on the text on p160 - "MyISAM.... MyISAM tables are not transaction safe, and they do not support full foreign key functionality." - I'm not sure to what extend MyISAM will meet my requirements?

InnoDB - text says:"...InnoDB tables also support full foreign key functionality in MySQL, unlike other tables..."

This implies that the other tables only support foreign keys in a limited manner - but how?

Can anybody help or guide me on this - please... ;o)

[u]</u>[u]</u>