data truncated for column XX at row 1

[Jaime del Palacio]

I have a problem whith my new install of mysql 5.0.11.

I have some code that executes the following sql through odbc:

insert into tbl (c1,c2) values ('v1','');

the table def is

c1 varchar(45)
c2 double default null

the insert statement use to work under mysql 4.xx but not it trows a "Data truncated for column c2 at row 1".

I understand (I think :) what's wrong with the insert (inserting a double as '') but, is there a way (change some settings) to make this work? what exactly is the problem inserting a numeric value that way?

Thanks in advance for any help.

Jaime