Nevermind, I got it. I just have to test to see if it works. Thanks
for your help!
On Apr 24, 3:49 pm, Mike C <snib...@gmail.com> wrote:
> Oh, I was looking for an example of how to use it like a piece of code
> or something.
>
> On Apr 24, 7:51 am, Frederick Cheung <frederick.che...@gmail.com>
> wrote:
>
>
>
> > On Apr 24, 9:23 am, Mike C <snib...@gmail.com> wrote:
>
> > > How can I use the :limit to change taggable_ type and context?
>
> > The limit tells mysql how much of the column to use for the index.
> > Pick values such that your total index length falls within the limit
> > (you're probably better off picking a smaller value for taggable_type,
> > you're very unlikely to have massively long values in that column)
>
> > Fred
>
> > > On Apr 24, 12:32 am, Frederick Cheung <frederick.che...@gmail.com>
> > > wrote:
>
> > > > On Apr 23, 11:23 pm, Mike C <snib...@gmail.com> wrote:
>
> > > > > I'm using the acts as taggable on plugin, and in the migrations
> > > > > there's a line of code to create an index:
>
> > > > > add_index :taggings, [:taggable_id, :taggable_type, :context], :name
> > > > > => "tagging_index", :limit => {:name => 10, :surname => 20}
>
> > > > > When I use unicode, the migration fails and I get told that the index
> > > > > is too long and can only be 1000 bytes. I switched over to ascii to
> > > > > see if I get the same problem and I didn't. I really want to use
> > > > > unicode, so I want to get this working.
>
> > > > If you want to limit the length of the prefix used for indexes, you'll
> > > > need to change name/surname up there for the string columns you want
> > > > to index (ie taggable_type and context) and change the numbers as
> > > > appropriate to your data
>
> > > > Fred
>
> > > > > I'm running Rails 3.0.7 with MySQL 5.1.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
