I found a place that say MYSQL has a limit for the size off the packet in relation with blob field. They say that you need to put this in the my.cnf "set-variable = max_allowed_packet=15M". With that you increase the size to 15 mb You can go and check the code in http://www.mysql-hispano.org/page.php?id=20&pag=2
Osvaldo Sommer -----Original Message----- From: Marco Paci [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 3:41 AM To: [EMAIL PROTECTED] Subject: Inserting blob Env: Win2003 Server, MySql 4.17 I've the following table CREATE TABLE TabellaTipi ( id int unsigned NOT NULL AUTO_INCREMENT, intero int, lungo bigint, decimale decimal(20,10), data datetime, stringa varchar(100), booleano tinyint unsigned, blobDati longblob, primary key (id) )TYPE=InnoDB; With a .Net application I'm developing I'm not able to insert a blob bigger than 500Kb in the table. I connected to MySql both natively and through ODBC but the result is always the same. I think the problem should be in the configuration of MySql service. Any suggestion? TIA Marco Paci Marco Paci Divisione Gestionale & Tecnologia PASSEPARTOUT s.a. Via Monaldo da Falciano, 3 - 47891 Falciano (Rep. San Marino) Tel. 0549.877910 From Abroad. +378 877910 [EMAIL PROTECTED] www.passepartout.sm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.648 / Virus Database: 415 - Release Date: 3/31/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.648 / Virus Database: 415 - Release Date: 3/31/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
