Hi all,
I have experienced some weird problems when using the Float field combined with the translation of setlocale() arguments.
It seems that with specific setlocale() (in my case setlocale('it_IT')) leads to transform the decimal separator from "."to "," (for example "2.566" is transformed to "2,566") so all queries contains a "," and mysql stores only the integer part (without any errors).
Good query:
INSERT INTO `field_testfloat` (pages_id, data) VALUES('1024', '24.534') ON DUPLICATE KEY UPDATE data=VALUES(data)
Bad query:
INSERT INTO `field_testfloat` (pages_id, data) VALUES('1024', '24,534') ON DUPLICATE KEY UPDATE data=VALUES(data)
The naive solution is to leave blank setlocale(), but i wonder if it is possibile to correct this behaviour.