# Decimal-field problem

**URL:** <https://www.ruby-forum.com/t/decimal-field-problem/116014>\
**Category:** Rails\
**Created:** [October 1, 2007, 5:10pm UTC](https://www.ruby-forum.com/t/decimal-field-problem/116014 "2007-10-01T17:10:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dertoni](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/9d8465/32.png) [@dertoni](https://www.ruby-forum.com/u/dertoni)\
**Post date:** [October 1, 2007, 5:10pm UTC](https://www.ruby-forum.com/t/decimal-field-problem/116014/1 "2007-10-01T17:10:01Z")

</div>

Hi,

I’m new to Ruby, Rails and this forum… so bear with me, thx.

I have kind of a strange problem…

I got a decimal field in a mysql table (precision 3, scale 1) for  
numbers like: “12”, or “12.4”; Problem is, whenever I input “0.5” as a  
number, rails stores “5.0” in the db…  
Even when I edit the db by hand, it displays “5.” ?

I just don’t get what’s going on. Do u got any ideas?

dertoni

---

<div class="post-metadata">

**Author:** ![dertoni](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/9d8465/32.png) [@dertoni](https://www.ruby-forum.com/u/dertoni)\
**Post date:** [October 1, 2007, 6:54pm UTC](https://www.ruby-forum.com/t/decimal-field-problem/116014/2 "2007-10-01T18:54:18Z")

</div>

Dertoni Dertoni wrote:

> Even when I edit the db by hand, it displays “5.” ?
> 
> I just don’t get what’s going on. Do u got any ideas?
> 
> dertoni

Maybe your problem is related to localization issues. Are you using some  
localization plugins, such as Globalize or any other?

You should see the content of log/development file to find how Rails is  
writing the SQL commands. Then you’ll have a hint of what is  
happening…

Anyway, check if you are using the latest version of Rails…

Good luck,

Rodrigo.

---

<div class="post-metadata">

**Author:** ![dertoni](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/9d8465/32.png) [@dertoni](https://www.ruby-forum.com/u/dertoni)\
**Post date:** [October 2, 2007, 12:15am UTC](https://www.ruby-forum.com/t/decimal-field-problem/116014/3 "2007-10-02T00:15:25Z")

</div>

Hi Rodrigo,

I’m using the Netbeans 6.0 Beta with the Ruby environment they provide  
with their ruby kit. Looking at the version numbers, almost everything  
is up-to-date, except Ruby which is a 1.8.5 (although it’s the JRuby  
variant not native Ruby).  
So I decided, to get the “original” and got Rails through Gems natively.  
So now, Ruby is at 1.8.6 and Rails still up-to-date, but obtained in  
another way than before, and guess what: Now it’s all working. So I  
guess something in Suns Distribution is still wonky…  
Well thanks for the hints 😉

dertoni

---

<div class="post-metadata">

**Author:** ![dertoni](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/9d8465/32.png) [@dertoni](https://www.ruby-forum.com/u/dertoni)\
**Post date:** [October 3, 2007, 2:46pm UTC](https://www.ruby-forum.com/t/decimal-field-problem/116014/4 "2007-10-03T14:46:17Z")

</div>

Dertoni Dertoni wrote:

> guess something in Suns Distribution is still wonky…  
> Well thanks for the hints 😉
> 
> dertoni

You’re welcome! 🙂