Hello.
I am running into an issue I would like to know if there is a solution
for. I am running Ruby version 1.8.6 and Rails 1.2.3. My database is
Oracle (10g) and I have one field defined as:
MY_FIELD NUMBER(1,0) DEFAULT ‘2’
When a record is created in the database the value that invariable
gets posted to the table is 0 (zero) instead of 2. However, if I
change the field to:
MY_FIELD NUMBER(2,0) DEFAULT ‘2’, the default value of 2 is correctly
posted.
I have the feeling that Ruby and/or Rails are considering the
NUMBER(1,0) field as a true/false container and anything that is not a
1 (true) will be converted to a 0 (false), including the default
value.
Any ideas why this is happening and/or how to solve it short or
modifying the column’s length?
Thanks in advance.
Pepe