问题数据在mysql-PHP中被截断

Question

I have this problem:

Warning: #1265 Data truncated for column

I got a form with a value coming from a text field : price.

When I put a decimal like : 45,56 ( French format)

My MySQL column type is a float.

Could someone help please ?

Answer 1

float data must be saved with a . "Dot" instead of a , "comma". 45.56

so before to save the data in the mysql, be sure that the format is correct.