ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> rubyonrails-talk
rubyonrails-talk
[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

Privacy Policy | Email Opt-out | Feedback | Syndication
© ActiveState Software Inc. All rights reserved