Hi, I'd found a bug when I'd tried to use blob fields and innoDb. To see the bug, do the follow:
*) Create a database. *) Import the dump file that is attached to this e-mail. (cfgimpressao.dump) *) Use the following commands: select Ci_Descricao from cfgimpressao; You will see that there is a row where Ci_Descricao is "Padrão". source mysql_blob_bug.sql select Ci_Descricao from cfgimpressao; Now, the record where Ci_Descricao is "Padrão" has disappear. The script you just executed didn't erase that. There are only update commands to change the blob contents. The bug is: The record where Ci_Descricao is "Padrão" mustn't be erased. The files are: cfgimpressao.dump <- The Dump Of Table mysql_blob_bug.sql <- The File of Blob Bug stored in the support.mysql.com/pub/mysql/secret Tnks in advance ! innodb,mysql,help ! ------------------------------------------------------------------------- ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento ------------------------------------------------------------------------- E S C R I B A I N F O R M A T I C A ------------------------------------------------------------------------- The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- ICQ : 1647350 $ look into "my eyes" Phone : +55 041 296-2311 look: cannot open my eyes Fax : +55 041 296-6640 ------------------------------------------------------------------------- Reply: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]