[Rails] Re: integer limit on migration doesn't have any effect?
by Michael Wang other posts by this author
Mar 31 2007 5:51PM messages near this date
[Rails] integer limit on migration doesn't have any effect?
|
[Rails] Re: integer limit on migration doesn't have any effect?
Reynard wrote:
>
> I have this code on migration file
>
> t.column :some_integer, :integer, :limit => 4
> t.column :other_integer, :integer, :limit => 8
>
> on mysql, I checked the datatype:
> some_integer INT(4)
> other_integer INT(8)
>
> but when I tried to enter a really big number to both fields (5
> billion which is bigger than INT(4) )
> both got truncated to 2147483647 which is the max for INT(4), and it's
> the same when I use :limit=>2 or :limit => 1
>
> is this mysql issue? I'm using mysql 4.1
If you insert some values directly in MySQL do you have the same problem?
--
Michael Wang
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Ta
lk" group.
To post to this group, send email to rubyonrails-talk@[...].com
To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@[...].com
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
Thread:
Reynard
Michael Wang
Reynard
|