Max_allowed_packet variable ??

[Li Sze]

Hi,

This is how I set the variables in the my.cnf file.

[mysqld]
set-variable = key_buffer_size=16M
set-variable = max_allowed_packet=16M

I can only insert 8M at any one time using SQLPutData. Even if I insert 1024K more, 
the SQLPutData will return a "Function sequence error". Does max_allowed_packet means 
half of what is stated? Coz I tried setting the max_allowed_packet=2M, and eventually 
I can only insert 1M at any one time.

I'm not sure whether I have to set any other variables as well. Please advise.

Thanks,
Li Sze