Dear MySQL Team

I still having problems with MySQL Blob fields. I'm porting some aplications that use Interbase and MS Sql Server to MySQL, and the blob fields are the only problem that i found until now. My MySQL version is shareware (after i solve this blob i will order some licences :) )

I have noticed that my problem only occurs when I try to load files with size greater than 64 K. All code above works perfectly with small files or pictures or text.

I'm using Delphi 4.0 + Delphi Service Pack 3 + BDE 5.01, in a Windows NT 4.0 / Service Pack 5.

mysql> status

-------------- C:\mysql\bin\mysql.exe Ver 9.13 Distrib 3.21.29a-gamma, for Win95 (i586)

Connection id: 7 Current database: Server version 3.21.29a-gamma-debug Protocol version 10 Connection localhost via TCP/IP TCP port 3306 Uptime: 24 min 33 sec

Running threads: 3 Questions: 54 Opened_tables: 9 Reloads: 1 Open tables: 5 Memory in use: 1116K Max memory used: 1156K

--------------

MyODBC Version 2.50.21.00. (Date 06/00/99 ?).

First of all, I (as sugested) change the variable max_allowed_packet to 10Mb, starting the MySQL server with the command : C:\mysql\bin>mysqld -Omax_allowed_packet=10000000

Ok, this works : C:\mysql\bin>mysqladmin variables ... | max_allowed_packet | 9999360 |

Now, in my Delphi program, if i try to load one Blob file small than 64k , everything is fine\, but if i try to save one image bigger than 64k i got the following message: "Project Project1.exe raised exception class EDBEngineError with message 'Record/Key deleted'."

After this , I think that the table is corrupt ! When i try to open this table again, i got the message : "[TCX][MyODBC]Got error 127 from table handler" , and i need to do one "DELETE ALL FROM testimage".

I have another question: Is important to me start MySQL as a NT service. But seems that I can't pass parameters (like -Omax_allowed_packet=xxx) to the server in this way ... There's any configuration file or something else to change ?

Thanks in advance for your atention and sorry for my bad english.

Best Regards Mario Prado - Brazil