Lo,

This is more for the archives than anything as there is a workaround.

When inserting 1234567890.123456 into a decimal(16,6) column, the value stored is 1234567890.123460

Having a brainwave from the Time::HiRes docs,
sprintf('%.6f', 1234567890.123456) stores the expected value.

Is this expected behaviour or should DBD::mysql automagically do the right thing?

John

Reply via email to