LARAVEL 4.1 probably issue on select float

Can you show your migration that created the float field? Is the value correct in the database?

I can show you, only the mysql code that migration generate.

id int(10) unsigned NOT NULL AUTO_INCREMENT, order_num int(11) NOT NULL, order_email varchar(255) COLLATE utf8_unicode_ci NOT NULL, order_shipping float NOT NULL, order_vat float NOT NULL, order_total float(8,2) NOT NULL, order_delivery_date varchar(255) COLLATE utf8_unicode_ci NOT NULL, order_state_id int(11) NOT NULL DEFAULT '0', order_invoice_mode int(11) NOT NULL DEFAULT '0', deleted_at timestamp NULL DEFAULT NULL, created_at timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', client_id int(10) unsigned NOT NULL DEFAULT '0'

the value is order_total. On db all these values are stored correctly, but i can't understand why, after select, this happened.

I'll tried to fetch data with the Query Builder

I'm not this will solve your issue but you should store financial data as decimal field types decimal(10,2) else you will encounter all kinds of rounding and inaccuracy errors.

http://www.heldit.com/2009/11/database/mysql-float-vs-decimal-money-datatype/

Thanks. This is really strange, maybe the fault is in php.ini, or httpd.config. But i'll try decimal field.

But if i try to execute a query by console all the float fields are fetched correctly. This is more strange.

robgeorgeuk you're right, with decimal all works. Thanks again! Cheers !!