> > > and more importantly what > > happens to the current data in the colum when changing its type to > > BLOB or VARCHAR BINARY? > > I'm not even sure mysql allows you to change column type.
It does - try ALTER TABLE. e.g. ALTER TABLE TABLENAME CHANGE COLUMN COLUMN NEWTYPE Never tried it with varchar -> blob, though (but we're using it for most all other types). - Aviram ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
