# AR cannot insert floats to mysql table (german conversion?)

**URL:** <https://www.ruby-forum.com/t/ar-cannot-insert-floats-to-mysql-table-german-conversion/64155>\
**Category:** Ruby\
**Created:** [June 22, 2006, 4:06pm UTC](https://www.ruby-forum.com/t/ar-cannot-insert-floats-to-mysql-table-german-conversion/64155 "2006-06-22T16:06:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rlwinter](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ecccb3/32.png) [@rlwinter](https://www.ruby-forum.com/u/rlwinter)\
**Post date:** [June 22, 2006, 4:06pm UTC](https://www.ruby-forum.com/t/ar-cannot-insert-floats-to-mysql-table-german-conversion/64155/1 "2006-06-22T16:06:37Z")

</div>

hi,  
i have a problem. i cannot insert a float value in a mysql tablecolumn  
FLOAT

Loading development environment.

> > Tax.create(:name=\>‘mwst’, :descr=\>‘MwSt. 16%’, :rate=\>0.16)  
> > ActiveRecord::StatementInvalid: Mysql::Error: Column count doesn’t  
> > match value count at row 1: INSERT INTO taxes (`name`, `descr`,  
> > `updated_at`, `rate`, `created_at`) VALUES(‘mwst’, ‘MwSt. 16%’,  
> > ‘2006-06-22 15:58:07’, 0,16, ‘2006-06-22 15:58:07’)  
> > from  
> > /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/connection\_adapters/abstract\_adapter.rb:120:in  
> > `log' from /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:185:in`execute’  
> > from  
> > /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/connection\_adapters/mysql\_adapter.rb:195:in  
> > `insert' [...]`save’  
> > from  
> > /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/base.rb:408:in  
> > `create’

in the insert statement 0.16 is converted to an invalid 0,16  
how can i stop that? i’m sure i’m missing something…

regards,  
robert